Display Deviances
When looking at a scorecard it is often of great interest to find out why a specific KPI has red or green status.
The scorecard table (Geography KPIs) shows sales KPIs for different geographical entities. When clicking on a row in the table, the Geography dimension in the filter will change and all web parts in the right column shows details for the selected geographical entity. The bar chart (Deviation from Plan, Bottom 5/Top 5 Products) shows the five most under performing and the five most over performing products. All other products perform better than “Specialty” and worse than “Vegetables”. The scorecard tables in the right column just lists the Bottom 5 and Top 5 products for the selected geographical entity.
The bottom scorecard table in the left column (Children of selected Geography KPI) shows the children of the selected geographical entity.
How to build?
Geography KPIs
The format settings gives the symbols for Status and Trend measures.
The check box “Use row indentation” gives the row indentation.
Enabling <FilterSelector> on rows gives the functionality to change the filter by clicking on the row.
Deviation from Plan, Bottom 5/Top 5 Products
This MDX statement gives both bottom 5 and top 5 members in one statement:
{{BottomCount([Product].[Product Name].Members, 5, [Measures].[Actual Plan Diff])},order({TopCount([Product].[Product Name].Members, 5, [Measures].[Actual Plan Diff])},[Measures].[Actual Plan Diff], BASC)}
Deviation from Plan, Bottom 5 Products
The Product dimension with this MDX statement {BottomCount([Product].[Product Name].Members, 5, [Measures].[Actual Plan Diff])} is placed on rows.