Adding Query Parameters to Analysis Reports
You must be logged into the Business Intelligence User Console, and have an Analysis report open for editing in order to continue.
Follow the below procedure to parameterize your MDX query in Analysis.
1. Right-click on the dimension member you want to create a parameter for, and select Filter from the context menu.
1. Select the level you want to set as the default parameter value. Then click the right arrow to move it to the list on the right.
2. Click the checkbox at the bottom of the window. Then type in a name for the parameter in the Parameter Name field.
3. Click OK.
Your parameter is now created as a filter in Business Intelligence Analysis. Whenever this Analysis report is run, users will have a selection of columns to filter by.
Note: If you create a dashboard with this Analysis report. Then this filter can be used by Dashboard Designer as a parameter as well.