Grouping of Measures in BISM
-
2012年4月26日 上午 04: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
所有回覆
-
2012年4月26日 下午 02: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
- 已標示為解答 krish9 2012年4月26日 下午 04:53
-
2012年4月26日 下午 04:53Yup. In fact implemented it the same way. Just wanted to check if there is any better way than that.
-
2012年7月20日 上午 06: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
