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


How the transformed data is written to an output file with column headers in U-SQL...

While working with U-SQL language, I noticed that there are few ways of writing data to an output file. Let's assume the SalesDetails....