IBM Cognos 10 Report Studio Practical Examples
Produktdetaljer
Om bidragsyterne
Filip Draskovic has spent his professional career, which covers the past 11 years, living and breathing IBM Cognos. For the first 8 years of his career, he had been an IBM Cognos consultant and developed his skills applying IBM Cognos Business Intelligence and Planning solutions in multiple industries. Wanting to do something different, he spent the next 3 years as a Cognos trainer teaching public and private IBM Cognos courses in IBM’s offices around North America. Following his desire to constantly gain new experiences and knowledge, he is currently filling the role of an IBM Cognos client technical professional. You can find him today in Toronto’s financial district. At home, with his wife, he is enjoying raising their son and daughter.
Roger Johnson is a learning consultant on IBM Cognos technologies delivering a wide variety of courses focusing on the needs of his learners. His education experience has been honed over years of work in training software professionals, college students, and many types of technology users. After he started his career as a computer programmer, a coworker said, “Hey, you do community theater productions. You would make a good trainer.” With those words, his career took a different direction. Over the next 20 years, he never moved too far from either technology or education. As a learner, he has masters degrees in Systems Management and Education. Currently, he is researching the end-user adoption of technology as his doctoral dissertation at Capella University. He calls Orlando home, but is regularly seen around North America delivering any number of IBM Cognos courses. When he is home, he enjoys the time he gets to spend with family, and his dogs keep him busy jogging around the lake.
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
Chapter 4 Overriding the Data Model 141
Creating a Union 142
Design 142
Step-by-Step 143
Joining SQL and Model Queries 156
Design 156
Step-by-Step 157
Summary 172
Chapter 5 Additional Examples 175
Using HTML to Enhance Functionality 176
Final Product 176
Design 176
Step-by-Step 177
Integrating Multiple Queries into a Complex Report 187
Final Product 188
Design 188
Step-by-Step 189
Summary 199
Chapter 6 New Techniques in Version 10 201
Using Active Reports to Replace HTML Code 202
Design 203
Step-by-Step 203
Adding Local Data Sources to Reports 207
Design 207
Step-by-Step 208
New Charting Options and Active Reports 220
Design 220
Step-by-Step 221
Statistical Analysis 247
Design 247
Step-by-Step 249
Summary 268
Index 271
Insider Techniques from Top IBM Cognos Trainers!
In this book, two leading IBM Cognos instructors show experienced users how to create better reports with less effort and take full advantage of IBM Cognos 10’s most valuable improvements. The authors walk through dozens of detailed examples built in response to actual business reporting challenges. Their step-by-step examples illuminate everything from report design and formatting to queries and statistical analysis--and every example is designed for easy modification.
The authors begin with techniques for creating more usable, “consumer-friendly” reports, and for ensuring that your reports match your analysis. Next, they demonstrate how to utilize the IBM Cognos report hierarchy and data models more effectively and introduce advanced techniques for report formatting and data processing. They conclude with a full chapter on IBM Cognos 10’s most powerful new tools--including Active Reports, support for local data sources, improved charting, and advanced statistical reporting.
Coverage Includes
• Creating simpler, more meaningful reports that match the way your users process information
• Quickly generating complex crosstab calculations
• Rapidly building interactive dashboards that illuminate management’s key metrics
• Taking full advantage of the IBM Cognos report hierarchy and layout library
• Comparing legacy report queries to new IBM Cognos Framework Manager data models
• Overriding the standard data model to reflect the way your company organizes its data
• Combining multiple queries in one complex report
• Providing access to interactive reports to users who aren’t connected to your servers
• Retrieving complex statistical analyses via the new IBM Cognos Statistics, powered by IBM SPSS
Take your IBM Cognos reports to a new level: learn from advanced reports taken straight from the classrooms of top IBM Cognos instructors!
- Fully reflects the expert-level design challenges IBM Cognos report developers encounter most often
- A combined tutorial and cookbook that demonstrates real-world solutions and integrates the authors' personal experiences as IBM Cognos instructors
- Shows how to create "consumer-friendly" reports, match reports to analysis, override data models, and use the newest Cognos 10 features
Produktdetaljer
Om bidragsyterne
Filip Draskovic has spent his professional career, which covers the past 11 years, living and breathing IBM Cognos. For the first 8 years of his career, he had been an IBM Cognos consultant and developed his skills applying IBM Cognos Business Intelligence and Planning solutions in multiple industries. Wanting to do something different, he spent the next 3 years as a Cognos trainer teaching public and private IBM Cognos courses in IBM’s offices around North America. Following his desire to constantly gain new experiences and knowledge, he is currently filling the role of an IBM Cognos client technical professional. You can find him today in Toronto’s financial district. At home, with his wife, he is enjoying raising their son and daughter.
Roger Johnson is a learning consultant on IBM Cognos technologies delivering a wide variety of courses focusing on the needs of his learners. His education experience has been honed over years of work in training software professionals, college students, and many types of technology users. After he started his career as a computer programmer, a coworker said, “Hey, you do community theater productions. You would make a good trainer.” With those words, his career took a different direction. Over the next 20 years, he never moved too far from either technology or education. As a learner, he has masters degrees in Systems Management and Education. Currently, he is researching the end-user adoption of technology as his doctoral dissertation at Capella University. He calls Orlando home, but is regularly seen around North America delivering any number of IBM Cognos courses. When he is home, he enjoys the time he gets to spend with family, and his dogs keep him busy jogging around the lake.