in a financial reporting cube we have a Scenario dimension (Actuals without adjustments, Adjustments, Actuals with adjustments, Plan, PriorYear, etc.). Until now we only had an attribute hierarchy (with IsAggregatable set to false).
=> all scenarios are at the same level
We added a lot of scenarios to the dimension and now having all these scenarios appearing all at the same level, doesn't make it very user-friendly. We would like to add some sort of classification.
What we would need is for example a classification
- Actuals without adjustments
- Actuals with adjustments
- Next scenario family
As you can see I would like to use the hierarchy only for classification purposes. I don't want the scenarios to aggregate up the hierarchy.
Is something like this possible without affecting performance
Thanks for your answer. Regards
View Complete Post