-
Book Overview & Buying
-
Table Of Contents
IBM Cognos 8 Report Studio Cookbook
By :
This recipe combines the techniques learned in prior recipes to achieve a business requirement. A report shows sales data by country and product line. Users can choose to see data for one or more countries.
However, we need to implement a security mechanism such that a user can choose only those countries to which he is supposed to have access. This is determined by the user groups he belongs to.
Create a simple list report with Country, City, Product line, and Sales Quantity as columns.
We will start by adding a filter for countries. For that, go to Query Explorer and insert a new detail filter. Define it as: [Country] in ?Countries?

Ensure that this filter is mandatory.
Now, add a new prompt page. Drag a value prompt on to it.
Follow the prompt wizard to set the following:
Link it to existing parameter called 'Countries'.
Create a new query for this prompt and call it 'Countries'.
Go to Query Explorer and open...
Change the font size
Change margin width
Change background colour