locked
KPI with 2 different data sources returning incorrect score RRS feed

  • Question

  • I created a PPS KPI using 2 different Analysis Services Cubes as the data sources. One cube contains the actual value (actual revenue) the other cube contains the target value (forecasted revenue). When I display the KPI score it's 100% even though the actual is less than the target. I've tried using different thresholds but that has no effect on the score. When I switch the target to a fixed value it calculates fine.

    The scoring pattern is 'Increasing is Better'. As a test, I did the same KPI with expense, but used 'Decreasing is better' and the result was always 0%.

    Am I missing something?
    Friday, May 15, 2009 5:21 PM