Recently, I was tasked with creating an internal Dashboard which allowed for Practice Leadership to track metrics related to sales pipeline change. The first thing that came to mind was a demo I had previously seen from someone at Microsoft. The functionality consisted of selecting a KPI in a Scorecard and having a Trend Chart on the Dashboard dynamically change to give a historical view of the selected measurement over time. The interactivity between Dashboard objects is new to PerformancePoint 2010 and I found this particular case to be most cool. The problem? I could not find documentation or anything online to achieve this result…so…after stumbling around for a few hours, here’s what I came up with:
Once your KPI’s are created, add a new custom property to the KPI in Dashboard Designer. The name can be whatever you like (I chose “MDX”) and the value needs to be the correct MDX syntax of the measurement:
If you have multiple KPI’s in the Scorecard that you would like to show up in the Trend Chart, it is important that you give all of the Custom Properties the same name on each KPI. Again, I chose “MDX”.
Next, a connector must be made between the Scorecard and the Trend Chart on the Dashboard. This is accomplished by connecting the “Measures” on the Chart with the Source Value of “KPI Row: MDX” from the Scorecard:
And that’s it! Save the changes, publish the Dashboard and you’ll have interactivity between the Scorecard and Chart that your analysts can use to their heart’s content.
Business Intelligence Consulting
Once your KPI’s are created, add a new custom property to the KPI in Dashboard Designer. The name can be whatever you like (I chose “MDX”) and the value needs to be the correct MDX syntax of the measurement:
If you have multiple KPI’s in the Scorecard that you would like to show up in the Trend Chart, it is important that you give all of the Custom Properties the same name on each KPI. Again, I chose “MDX”.
Next, a connector must be made between the Scorecard and the Trend Chart on the Dashboard. This is accomplished by connecting the “Measures” on the Chart with the Source Value of “KPI Row: MDX” from the Scorecard:
And that’s it! Save the changes, publish the Dashboard and you’ll have interactivity between the Scorecard and Chart that your analysts can use to their heart’s content.
Business Intelligence Consulting