Create PerformancePoint Filter and Set a Default Value for the Filter

We can create a Filter for a PerformancePoint page easily. When you open the Dashboard page in PerformancePoint Dashboard Designer, you can see the Filters tab. Just click on it and you can see Filters there. Then click on New Filter as shown in the below figure.

Follow the wizard by providing a name and the data source, then you will get a screen to select members for the filter as shown in the below figure.

In the shown figure Filter members are already selected. But you can set the default value for the filter while selecting the filter members. To do it, just select the member value and right click on it. Then you will get a screen as shown below.

Select Set as Default Selection as shown in the above figure and after that you will get a screen as below showing the default selection.

Then just follow the other steps to add the filter...


  1. how do we set a default value if we create a filter from MDX formula?

  2. Not feasible with MDX or named set


Getting Error Description and Error Column Name in SSIS 2016...

If you check the Error Output Path of a SSIS Data Flow component, it only contains the ErrorCode and the ErrorColumn (actually this the I...