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:
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