PERFORMANCE CANVAS

The Best Practice in Financial Control - EPM, CPM, Budgets, Reports, Plans, Dashboards, KPI Management, Scorecards & Consolidation

User Tools

Site Tools


pe:displaydeviances

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.


Children of selected Geography KPI


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

pe/displaydeviances.txt · Last modified: 2014/03/03 06:49 by pcevli