IBM Cognos 10 Report Studio : Practical Examples

by Draskovic, Filip; Johnson, Roger

Edition:

1st

ISBN13:

9780132656757

ISBN10:

0132656752

Format:

Paperback

Pub. Date:

10/18/2011

Publisher(s):

IBM Press

Other versions by this Author

List Price: ~~$59.99~~

Rent Book

(Recommended)

Term

Due

Price

Short Term

Aug 2

$47.99

Semester

Oct 2

$53.99

Quarter

Aug 23

$50.99

$47.99

Buy New Book

Currently Available, Usually Ships in 24-48 Hours

$50.99

eBook

180 day subscription

$32.99

Used Book

We're Sorry
Sold Out

More New and Used
from Private Sellers

Starting at $36.81

Questions About This Book?

Why should I rent this book?

Renting is easy, fast, and cheap! Renting from eCampus.com can save you hundreds of dollars compared to the cost of new or used books each semester. At the end of the semester, simply ship the book back to us with a free UPS shipping label! No need to worry about selling it back.

How do rental returns work?

Returning books is as easy as possible. As your rental due date approaches, we will email you several courtesy reminders. When you are ready to return, you can print a free UPS shipping label from our website at any time. Then, just return the book to your UPS driver or any staffed UPS location. You can even use the same box we shipped it in!

What version or edition is this?

This is the 1st edition with a publication date of 10/18/2011.

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 CDs, lab manuals, study guides, etc.
The Rental copy of this book is not guaranteed to include any supplemental materials. You may receive a brand new copy, but typically, only the book itself.

Summary

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.

About the Authors	p. xvi
Foreword	p. xvii
Preface	p. xviii
Creating Consumer-Friendly Reports	p. 1
Highlight Selected Text	p. 1
Design	p. 2
Step-by-Step	p. 2
Avoiding Query Macros	p. 10
Design	p. 12
Step-by-Step	p. 13
Complex Crosstab Calculations	p. 20
Design	p. 20
Step-by-Step	p. 21
Summary	p. 24
Matching the Report to the Analysis	p. 27
The Dashboard	p. 28
Design	p. 28
Step-by-Step	p. 29
Prompting from an Entire Hierarchy	p. 45
Design	p. 45
Step-by-Step	p. 45
Additional Dimensional Functions	p. 58
Design	p. 58
Step-by-Step	p. 59
Master-Detail Report from Two Separate Lists	p. 70
Design	p. 70
Step-by-Step	p. 70
Configuring the Interactive Dashboard	p. 82
Scenario	p. 82
Design	p. 82
Step-by-Step	p. 82
Summary	p. 89
Understanding the Report Hierarchy	p. 91
Layout Library	p. 91
Design	p. 92
Step-by-Step	p. 92
Using the Layout Library	p. 100
Design	p. 100
Step-by-Step	p. 101
Inheriting Formatting	p. 109
Design	p. 109
Step-by-Step	p. 110
Inheriting Structure	p. 120
Design	p. 120
Step-by-Step	p. 120
Creating the Briefing Book	p. 127
Design	p. 127
Step-by-Step	p. 127
Summary	p. 140
Overriding the Data Model	p. 141
Creating a Union	p. 142
Design	p. 142
Step-by-Step	p. 143
Joining SQL and Model Queries	p. 156
Design	p. 156
Step-by-Step	p. 157
Summary	p. 172
Additional Examples	p. 175
Using HTML to Enhance Functionality	p. 176
Final Product	p. 176
Design	p. 176
Step-by-Step	p. 177
Integrating Multiple Queries into a Complex Report	p. 187
Final Product	p. 188
Design	p. 188
Step-by-Step	p. 189
Summary	p. 199
New Techniques in Version 10	p. 201
Using Active Reports to Replace HTML Code	p. 202
Design	p. 203
Step-by-Step	p. 203
Adding Local Data Sources to Reports	p. 207
Design	p. 207
Step-by-Step	p. 208
New Charting Options and Active Reports	p. 220
Design	p. 220
Step-by-Step	p. 221
Statistical Analysis	p. 247
Design	p. 247
Step-by-Step	p. 249
Summary	p. 268
Index	p. 271
Table of Contents provided by Ingram. All Rights Reserved.