Skip to main content

Cloud

Connecting Scorecards and Charts

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:
clip_image001
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:
clip_image002
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.
clip_image004
clip_image006
Business Intelligence Consulting

Technorati Tags: PerformancePoint,Business Intelligence Consulting,,,

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

PointBridge Blogs

More from this Author

Follow Us