Adding a prompt into Slicer and its limitations
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.
Getting ready
We will use the report that we created in the previous recipe for this recipe. We will need to remove Golf Equipment used in the previous recipe from Slicer.
How to do it...
In this recipe we will see how to add a prompt into Slicer, as follows:
Open the Query Explorer and explore the query being used by crosstab. Remove the Golf Equipment filter from the Slicer section.
From the Toolbox pane, drag a new Slicer Member Set under Slicer.
Define the set as:
[sales_and_marketing].[Products].[Products].[Product line]->?pProductLine?
Run the report to test it.
How it works...
When you run the report, you will set Cognos to automatically prompt you to select a Product line value. When you select one, the report runs and pulls data for the selected Product line...
