Skip to Main Content
IBM Cognos 8 Report Studio Cookbook
book

IBM Cognos 8 Report Studio Cookbook

by Abhishek Sanghani
June 2010
Intermediate to advanced content levelIntermediate to advanced
272 pages
5h 55m
English
Packt Publishing
Content preview from IBM Cognos 8 Report Studio Cookbook

Reducing 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 the minimal. In this recipe, we will see some good practices to ensure this.

Getting ready

We will use the dimensional GO Sales SSAS Cube package for this.

From Tools | Options, check the options of Alias member unique name and uncheck Delete unreferenced query objects.

Getting ready

How to do it...

  1. We will start by creating a simple crosstab report. Open Cognos Report Studio for a new crosstab report. Drag Time Month Dim | Current Year level on the columns.
  2. From the Insertable Objects pane, drag a new Set ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

IBM Cognos 8 Planning

IBM Cognos 8 Planning

Ned A Riaz, Jason Edwards, Rich Babaran
IBM Cognos Dynamic Cubes

IBM Cognos Dynamic Cubes

Dmitriy Beryoza, Shilpa Bhimavarapu, Alan Blake, David Cushing, Vlaunir Da Silva, Mario Daigle, Avery Hagleitner, Ian Henderson, Beth Jubera, Skyla Loomis, Chris McPherson, Steven Rogers, Carlos Ruiz, Christopher Yao
IBM Cognos Dynamic Cubes

IBM Cognos Dynamic Cubes

Dmitriy Beryoza, MaryAlice Campbell, Cesar Cardorelle, Tod Creasey, David Cushing, Vlaunir Da Silva, Sean David, Avery Hagleitner, Ian Henderson, Daniel Howell, Igor Kozine, Paul Prieto, Paul Thompson, Jose Vazquez, Ying Zhang

Publisher Resources

ISBN: 9781849680349Other