PerformancePoint: Why can’t I see values for my KPI’s Actual and Target metrics in a scorecard?
While working on a KPI in PPS, I found that after binding an Actual and Target to my cube I couldn’t see values for these metrics after adding the KPI to Scorecard and updating. The indicator image these metrics showed was “No Data”.
I broke out ProClarity to make sure that data existed, and it did.
Turns out the culprit was another Target that lived in the same KPI – I had written an MDX tuple formula for it, and fat fingered the MDX itself. Unfortunately, it looks like we’re not verifying MDX syntax, so the UI happily accepted my “bad” MDX, which subsequently caused all data values in the KPI to die. After correcting my MDX, all was well.