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.
Les mer
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   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
Les mer
Take Your IBM Cognos 10 Reporting Skills to the Next Level: 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
Les mer
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
Les mer

Produktdetaljer

ISBN
9780132656757
Publisert
2011-11-02
Utgiver
Vendor
IBM Press
Vekt
500 gr
Høyde
230 mm
Bredde
179 mm
Dybde
17 mm
Aldersnivå
P, UF, 06, 05
Språk
Product language
Engelsk
Format
Product format
Heftet
Antall sider
320

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.