Adding prompt into slicer and its limitation

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

Create a simple crosstab report with Organization Code 2 on rows and Current Year and Current Months on columns.

How to do it...

  1. Open the Query Explorer and explore the query being used by crosstab.
  2. From Insertable Objects pane, drag a new Set Expression under Slicer.
  3. Define the set as: [GO Finance Fact].[Submission Dim].[Submission Dim].[Submission Currency En]->?SubmissionCcy?.
    How to do it...
  4. Run the report to test it.

How it ...

Get IBM Cognos 8 Report Studio Cookbook 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.

Start your free trial