We use Projects, with a dimension assigned for category. We also have budgets established for analysis at the Project/Category dimension. We are looking for a way to report on budget vs actual data at the project and category detail level but filter projects by status (for example, we don't want to look at closed projects).
We use BI FSM and have looked through the Projects reporting in CloudSuite but can't find a place where status and a dimension can be viewed in the same place. Does anyone have a similar setup and a solution we are missing?