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? ...
Get IBM Cognos 10 Report Studio Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
