SPECIAL OFFERS
Keep up with new releases and promotions. Sign up to hear from us.
Rough Cuts are manuscripts that are developed but not yet published, available through Safari. Rough Cuts provide you access to the very latest information on a given topic and offer you the opportunity to interact with the author to influence the final publication.
This is the Rough Cut version of the printed book.
IBM Cognos 10 is the next generation of 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. About the Authors xvi
Foreword by Erin Pyka xvii
Preface xviii
Chapter 1 Creating Consumer-Friendly Reports 1
Highlight Selected Text 1
Design 2
Step-by-Step 2
Avoiding Query Macros 10
Design 12
Step-by-Step 13
Complex Crosstab Calculations 20
Design 20
Step-by-Step 21
Summary 24
Chapter 2 Matching the Report to the Analysis 27
The Dashboard 28
Design 28
Step-by-Step 29
Prompting from an Entire Hierarchy 45
Design 45
Step-by-Step 45
Additional Dimensional Functions 58
Design 58
Step-by-Step 59
Master-Detail Report from Two Separate Lists 70
Design 70
Step-by-Step 70
Configuring the Interactive Dashboard 82
Scenario 82
Design 82
Step-by-Step 82
Summary 89
Chapter 3 Understanding the Report Hierarchy 91
Layout Library 91
Design 92
Step-by-Step 92
Using the Layout Library 100
Design 100
Step-by-Step 101
Inheriting Formatting 109
Design 109
Step-by-Step 110
Inheriting Structure 120
Design 120
Step-by-Step 120
Creating the Briefing Book 127
Design 127
Step-by-Step 127
Summary 140