non-leaf KPI score is 100% when children KPIs has no value RRS feed

  • Question

  • Hello,

    we are having a problem with non-leaf KPI score when children KPIs actual/target returned as null from SSAS cube the non-leaf KPI score is 100% and its indicator is green.

    the reason behind that is that PPS rolls up null values as 0s so, in the non-leaf KPI it considers actual 0 and target 0, so comparing both it detects the score as actual meets target and score is 100% and indicator is green

    following is an example describing the KPI hierarchy causes the problem:

    -(non-Leaf) ObjKPI

    -(leaf) KPI

    the leaf KPI has Actual and targets are MDX expressions from SSAS Data source, which having no value and return null

    the ObjKPI is non-leaf KPI with Rollup type is set to sum of children, and "use calculated values from children" checkbox is checked.

    I want PPS to rollup null values as null not zero, I want a solution to handle this problem

    Monday, February 25, 2013 12:00 PM