Reducing the number of query items
From the maintenance and documentation perspective, it is advisable to keep the number of query items in report query subjects to minimal. In this recipe, we will see some good practices to ensure this.
Getting ready
We will use the dimensional GO Sales (analysis) package for this recipe.
From Tools/Options, check the option of Alias member unique name and uncheck Delete unreferenced query objects.
How to do it...
In this recipe we will see how to use some useful options available in Cognos Report Studio. This can be helpful and will make the reports more clear. To do this, perform the following steps:
We will start by creating a simple crosstab report. Open IBM Cognos Report Studio for a new crosstab report. Drag the Time/Year level onto columns.
From the Toolbox pane, drag a new Query Calculation onto rows.
Give it a name, for example,
ProductLinesand choose the Products hierarchy.
In the Set Expression window, expand the Products hierarchy to locate children...
