In the previous recipe, we saw that we can filter the whole report by a member or member set, using Slicer. This recipe will show you how to add a prompt into Slicer to make it dynamic.
Create a simple crosstab report with Organization Code 2 on rows and Current Year and Current Months on columns.
Open the Query Explorer and explore the query being used by crosstab.
From Insertable Objects pane, drag a new Set Expression under Slicer.
Define the set as:
[GO Finance Fact].[Submission Dim].[Submission Dim].[Submission Currency En]->?SubmissionCcy?
.Run the report to test it.
When you run the report, you will set the Cognos to automatically prompt you to select a Submission Currency. When you select one, the report runs and pulls data for selected Submission Currency.
Here, we are using Slicer for the same application as in the previous recipe. However, instead of hard-coding a particular member, we are making...