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.




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.




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)}



The Product dimension with this MDX statement {BottomCount([Product].[Product Name].Members, 5, [Measures].[Actual Plan Diff])} is placed on rows.



The Geography dimension with this MDX statement _FILTERTUPLE_.Item(0).Children is placed on rows.

  • pe/displaydeviances.txt
  • Last modified: 2014/03/03 12:49
  • by pcevli