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...
Business Intelligence, Data Warehousing, OLAP Implementation, Reporting and many more...
Subscribe to:
Post Comments (Atom)
tablename_WriteToDataDestination: Mashup Exception Data Source Error Couldn't refresh the entity...
Once a Dataflow is created and published on Fabric, got the below error while refreshing the Dataflow. tablename_ WriteToDataDestination: M...
-
In SQL Report Subscription, you may want to send the report with the link and you can do it by selecting Include Link value. But some time...
-
In SQL Server Analysis Services Cube, there may be a situation where we need to combine two related fact tables. This kind of a situation ma...
-
When I tried to connect to a SharePoint URL in dashboard designer options, it prompt a message saying "The URL is not available, does n...
how do we set a default value if we create a filter from MDX formula?
ReplyDeleteNot feasible with MDX or named set
ReplyDeleteThanks a Lot Gopika...
ReplyDeleteThanks a lot Gopika!!!
ReplyDelete