Grouping of Measures in BISM

Question

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

Answer 1

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

Answer 2

Yup. In fact implemented it the same way. Just wanted to check if there is any better way than that.

Answer 3

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