How to design the KPI, when it is drillon it should show the sub-measures apart from the dimensions

[Former Member]

Hi Experts,

I have a requirement. When a KPI for example KPI1 is drill-down it should show the sub measures who's values will be summed up to the KPI1.

Example: Using the Index KPI the sub-measures can be displayed as below.

+Perspective1  

  +Objective1

    +KPI1             

      -Measure1    

      -Measure2   

      -Measure3    

But don't want to be displayed in the scorecard but when we go for the drill down it show the sub-measures with dimension.

Dimension = Location

under Drill Tab:

+Location 1

   + KPI 1

      -Measure1

      -Measure2

      -Measure3

+Location 2

  +KPI1

     -Measure1

     -Measure2

   +KPI2

      -Measure4

      -Measure5

+Location 3

   +KPI4

      -Measure 7

      -Measure 8

Please can anyone suggest me a solution for this scenario.

Thanking you,

Regards

Vinay.

[Former Member]

KPIs are the base level and so it would be non-standard to put measures under them. Perhaps if you could provide more detail on the actual example we might be able to provide a different solution.

[Former Member]

Dear Clifford Stinson,

Here I am giving an example:

Under these Customer dimension hierarchy we need to have some other sub measures like

Repeated Customers - Should be drill down to its sub measure 1 (Some ratio)

Infrequent Customer  - Should be drill down to its sub measure 2

First Time Customer  - Should be drill down to its sub measure 3

Like this we need to drill down a KPI from its dimension to its sub measure.

Can we do it in the scorecard itself or in the report. Please suggest me a solution for this scenario.

Hope I am clear this time.

Thanking you,

Regards

Vinay.

[Former Member]

In this case the scorecard is not a good place to display the sub-measures. This is a limitation of the SSM product. However you can use reports and dashboards to show a KPI and the supporting sub-measures.