Monday, June 27, 2011

Creating Time Filters in PerformancePoint Dashboard Designer

This post is about creating time filters in PerformancePoint Dashboard Designer, as the title suggests. Of course there are more than one way to do this, but one very simple way is to correctly add Time Intelligence (you can ask me how to do this) to your cube in BIDS and then when you are working in Dashboard Designer, you can add a "Member Name" filter. For this filter, you have to then choose the correct time dimension that is associated with your cube. Once you have chosen the correct time dimension, select the members of the hierarchy, that you want to use for the filter. Once you are done configuring the filter, you have to create a connection between it and the region that you want to be influenced by this filter.

To do this, you can add your filter to one of your dashboards, for instance. Towards the right side of the filter, there should appear a down arrow, that, when clicked, will give you two options, one of which will be Create Connection. Click on this and then select the item that you want to connect to e.g a chart). On the Values tab select the time dimension of the chart that you want to connect to and then you can select Member Unique Name in the bottom drop-down list.

Your filter should now be configured correctly. Save and deploy your Dashboard. Test it.


No comments:

Post a Comment