Use a Multi-Source Session Variable in a Data Filter

After you create the MVCOUNTRY multi-source session variable, you can use it in a data filter.

The MVCOUNTRY multi-source session variable is displayed in the Expression Editor's Variables tab. For information about the MVCOUNTRY session variable used in this example, see Create a Multi-Source Session Variable.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Browse for and open a logical or presentation table.
4. Click the Data Filters tab.
5. Go to the Add field, enter the application role that you want to set the data filter for, click Search by Role Name, and from the list select the application role.
6. In the Role Name list, click the role you added to highlight it, and then click Open Expression Editor.
7. Enter this expression:
   Country=VALUEOF(NQ_SESSION.MVCOUNTRY)
8. Optional: Click Validate.
9. Click Save to save the expression.
10. Click Save to save the semantic model.