KPI, complex target RRS feed

  • Question

  • I need to define an indicator with personalized target for all levels of the time
    hierarchy like this:

    January Target 10%

    February Target 23%

    First Semester Target 34%
    Second Semester Target 42%

    Year target 38%

    So, when I drag the indicator over the scorecard, and I drag a year over the X-axis I want to see the actual value and the year target... then when I drag a Month over X-axis I want to see the respective month target...

    now I have the target values in a SQL table like this:

    Calendar 2009    38%
    January 2009       10%
    Febrary 2009     23%

    And the actual values for the KPI in a SSAS cube

    Friday, March 20, 2009 6:39 PM