Grouping of Measures in BISM
-
jueves, 26 de abril de 2012 4:51
Team -- We have a BISM/PowerPivot model where we have the core 3 measures i.e. Sales Actuals, Sales Budget & Sales Forecast. In addition to them we have variance measures and percentages. On top of these we have more calculations. All together we have like 50 + measures. When the user opens the pivot in PowerView or in Excel, user is seeing a long list. Is there a way to group the measures into seperate folders (just like how SSAS does)?
Thanks
Krish
Todas las respuestas
-
jueves, 26 de abril de 2012 14:33
By now you can only create empty tables (no visible columns, no rows, you can create one by writing a SELECT NULL AS Dummy statement as a query) and put there the measures you want to group together. Give to the table the name of the Group you want to display.
Marco
Marco Russo http://www.powerpivotworkshop.com http://sqlblog.com/blogs/marco_russo
- Marcado como respuesta krish9 jueves, 26 de abril de 2012 16:53
-
jueves, 26 de abril de 2012 16:53Yup. In fact implemented it the same way. Just wanted to check if there is any better way than that.
-
viernes, 20 de julio de 2012 6:08
What happens if we use PerformancePoint 2010 to read the Tabular model? I'm not too sure about this but I believe the user experience will be slightly different won't it? For example we will see:
a) Measures in "Dimension" nodes but in actual, they are Measures in Fact tables (which logically are supposed to appear under Measure node).
b) The only measures that are seen in PPS under the Measure Node are the calculated measures build in Tabular. In this case, how can we build groupings such that PPS is able to segregate out these measures accordingly?
Bernard
