O'Reilly logo

IBM Cognos 10 Report Studio Cookbook - Second Edition by Abhishek Sanghani, Ahmed Lashin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

  1. Open the Query Explorer and explore the query being used by crosstab. Remove the Golf Equipment filter from the Slicer section.
  2. From the Toolbox pane, drag a new Slicer Member Set under Slicer.
  3. Define the set as:

    [sales_and_marketing].[Products].[Products].[Product line]->?pProductLine? ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required