IBM Cognos 10 Report Studio Practical Examples

by ;
  • ISBN13:


  • ISBN10:


  • Edition: 1st
  • Format: Paperback
  • Copyright: 2011-10-18
  • Publisher: IBM Press
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $64.99 Save up to $9.75
  • Buy New
    Add to Cart Free Shipping


Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.


IBM Cognos 10 is the next generation off the leading performance management, analysis, and reporting standard for mid- to large-sized companies. One of the most exciting and useful aspects of IBM Cognos software is its powerful custom report creation capabilities. After learning the basics, report authors in the enterprise need to apply the technology to reports in their actual, complex work environment. This book provides that advanced know how. Using practical examples based on years of teaching experiences as IBM Cognos instructors, the authors provide you with examples of typical advanced reporting designs and complex queries in reports. The reporting solutions in this book can be directly used in a variety of real-world scenarios to provide answers to your business problems today. The complexity of the queries and the application of design principles go well beyond basic course content or introductory books. IBM Cognos 10 Report Studio: Practical Examples will help you find the answers to specific questions based on your data and your business model. It will use a combination tutorial and cookbook approach to show real-world IBM Cognos 10 Report Studio solutions. If you are still using IBM Cognos 8 BI Report Studio, many of the examples have been tested against this platform as well. The final chapter has been dedicated to showing those features that are unique to the latest version of this powerful reporting solution.

Author Biography

Filip Draskovic is a former IBM Business Intelligence Education Specialist. He has extensive experience with both the technical and business aspects of complex IBM Cognos Business Intelligence and Planning projects, from planning and project management through hands-on solution development, testing, deployment, and training. Currently, Filip is part of IBM Business Analytics Client Technical Professional team in Toronto, Canada. Roger Johnson is an IBM Business Analytics Learning Consultant based in Orlando, Florida. He has provided technical training to IBM Cognos customers, partners, and employees since 2006, teaching data modeling, report writing, scorecarding, and OLAP cube development courses.

Table of Contents

About the Authorsp. xvi
Forewordp. xvii
Prefacep. xviii
Creating Consumer-Friendly Reportsp. 1
Highlight Selected Textp. 1
Designp. 2
Step-by-Stepp. 2
Avoiding Query Macrosp. 10
Designp. 12
Step-by-Stepp. 13
Complex Crosstab Calculationsp. 20
Designp. 20
Step-by-Stepp. 21
Summaryp. 24
Matching the Report to the Analysisp. 27
The Dashboardp. 28
Designp. 28
Step-by-Stepp. 29
Prompting from an Entire Hierarchyp. 45
Designp. 45
Step-by-Stepp. 45
Additional Dimensional Functionsp. 58
Designp. 58
Step-by-Stepp. 59
Master-Detail Report from Two Separate Listsp. 70
Designp. 70
Step-by-Stepp. 70
Configuring the Interactive Dashboardp. 82
Scenariop. 82
Designp. 82
Step-by-Stepp. 82
Summaryp. 89
Understanding the Report Hierarchyp. 91
Layout Libraryp. 91
Designp. 92
Step-by-Stepp. 92
Using the Layout Libraryp. 100
Designp. 100
Step-by-Stepp. 101
Inheriting Formattingp. 109
Designp. 109
Step-by-Stepp. 110
Inheriting Structurep. 120
Designp. 120
Step-by-Stepp. 120
Creating the Briefing Bookp. 127
Designp. 127
Step-by-Stepp. 127
Summaryp. 140
Overriding the Data Modelp. 141
Creating a Unionp. 142
Designp. 142
Step-by-Stepp. 143
Joining SQL and Model Queriesp. 156
Designp. 156
Step-by-Stepp. 157
Summaryp. 172
Additional Examplesp. 175
Using HTML to Enhance Functionalityp. 176
Final Productp. 176
Designp. 176
Step-by-Stepp. 177
Integrating Multiple Queries into a Complex Reportp. 187
Final Productp. 188
Designp. 188
Step-by-Stepp. 189
Summaryp. 199
New Techniques in Version 10p. 201
Using Active Reports to Replace HTML Codep. 202
Designp. 203
Step-by-Stepp. 203
Adding Local Data Sources to Reportsp. 207
Designp. 207
Step-by-Stepp. 208
New Charting Options and Active Reportsp. 220
Designp. 220
Step-by-Stepp. 221
Statistical Analysisp. 247
Designp. 247
Step-by-Stepp. 249
Summaryp. 268
Indexp. 271
Table of Contents provided by Ingram. All Rights Reserved.

Rewards Program

Write a Review