Monday, May 21, 2012

Set Default Value of PerformancePoint Filter

        Basically default value of  a PerformancePoint filter is the default value of  the  relevant dimension. Following shows how to set default value of SSAS dimension. In my example I use dimTime dimension. I want to create a filter using dimTime dimension.






I’m going to use YearMonth member of dimTime dimension for the filter. So I set default value of YearMonth as shown in above figure.


Set Default Value Dynamically

Moreover we can use MDX expression to set the default value dynamically. Using that we can change the default value according to purpose.








Above MDX expression use to set the current month as default value in my scenario.
Now when I create PerformancePoint filter, this value becomes the default value.!!


 


Posted by at
Labels: , , , ,

4 comments:

  1. AnonymousAugust 26, 2013 at 3:56 AM

    Would you please tell how to open dialogs you mentioned in the post? I see nothing in SharePoint 2010.

    ReplyDelete
    Replies
    1. Anushka WeerakkodygeAugust 27, 2013 at 7:48 AM

      Hi,

      This is all about a performance point filter's default values. Please visit following link where you can see more comments regarding your matter.

      http://altecnotes.wordpress.com/2011/11/21/set-default-value-of-performancepoint-filter/

      Delete
  2. AnonymousSeptember 9, 2014 at 4:29 AM

    Hi,
    Can i get a key for the corresponding values in PPS Filter.?

    ReplyDelete
  3. Anushka WeerakkodygeSeptember 9, 2014 at 10:25 AM

    Hi,
    As you can see I have used attribute key in above expression.

    ReplyDelete

Subscribe to: Post Comments (Atom)