none
Negative KPI RRS feed

  • Question

  • Hi,

    Have a unique requirement here.   I am creating a scorecard that has multiple KPI's in it.   There is  a roll up such:

    Top Objective
       KPI_A
         KPI_B
         KPI_C
       KPI_D

    So by default I can have KPI_B & KPI_C roll-up and add to KPI_A.   Then KPI_A and KPI_D will be added to get my Top Objective.  No problem.

    But for this particular view, I need to have KPI_D subtracted from KPI_A.

    Is there a way to handle this?  I could go back an create a calculated member in the cube but am trying to avoid doing that for other reasons.

    Alan



    My Ramblings @ http://alanwhitehouse.wordpress.com
    Thursday, December 10, 2009 2:09 PM