Suppose that you want to filter the Grid dynamically by selecting the required category or several categories. To do this, perform the following steps.
To add the query containing category names, click the Add Query button in the Query group on the Data Source ribbon tab.
In the invoked Query Editor, click the Run Query Builder... button.
The Query Builder will be invoked. To add the Categories table to a query, double-click this table and select all columns.
Click OK. The Query Editor will display the generated SQL query.
Click Finish to add the Categories query to the data source.
To create a dashboard parameter, click the Parameters button in the Home ribbon tab.
In the invoked dialog, click Add to create a new parameter. Then, specify its settings in the following way.
Click OK to create the dashboard parameter.
To pass the created parameter to a filter string, select the Grid and click the Edit Filter button in the Data tab.
In the invoked Filter Editor, click the button to insert a new condition.
Make sure that the CategoryName dimension is selected in a created condition. Then, select the Is any of criteria operator from the list.
Click the button next to the <enter a value> operand value, then click the button. The categoryParameter will be selected as an operand value (note that the icon will be displayed next to the selected parameter).
Select required categories in the Value column, click OK and click the Submit button. The Grid will be filtered according to the selected categories.