Take your IBM Cognos reports to a new level: learn from advanced reports taken straight from the classrooms of top IBM Cognos instructors!
In this book, two leading IBM Cognos instructors show experienced Cognos users exactly how to take their reporting to the next level. Drawing on the best examples they've created in response to their students' real business challenges, the authors show how to design reports more effectively, prepare complex queries that run more efficiently, overcome common reporting problems, and generate more meaningful information. The authors share personal insights and examples from their unsurpassed experience working with hundreds of users of IBM Cognos reporting tools in multiple business roles and environments. Combining a step-by-step tutorial and 'cookbook' approach, they provide multiple reporting examples that professionals can easily adapt to their own requirements. Coverage includes:
| 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. |
ISBN: 9780132656757
ISBN-10: 0132656752
Audience:
General
Format:
Paperback
Language:
English
Number Of Pages: 320
Published: 18th October 2011
Dimensions (cm): 23.2 x 17.8
x 1.6
Weight (kg): 0.5