on ‎2016 Jul 05 11:03 AM
SAP EPM 10 - NW
How to generate a report by a dimension property without having the dimension in row axis?
In the example report shown in attached mockup , i need a report generated by product class (suppressed for zero) summarized on all products
You can't use property to aggregate! Use hierarchy - existing or new!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Vadim. Unfortunately i can't create a hierarchy in this situation. Decided to segregate
data using flow dimension by creating further breakdown in flow corresponding to each product class.
"Decided to segregate
data using flow dimension by creating further breakdown in flow corresponding to each product class. " - no idea how it will help...
If you take products on row axis then through Member Sorting & Grouping, aggregates can be done based on property as it creates the local member.
Hope it helps.
Astha
It's not a database aggregate, it's just an Excel calculation in local member....
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.