IBM Cognos 8 Report Studio Cookbook

There is a newer version of this book available - IBM Cognos 10 Report Studio Cookbook, Second Edition
IBM Cognos 8 Report Studio Cookbook
eBook: $35.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $95.98    Print cover: $59.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters


  • Learn advanced techniques to produce real-life reports that meet business demands
  • Tricks and hacks for speedy and effortless report development and to overcome tool-based limitations
  • Peek into the best practices used in industry and discern ways to work like a pro
  • Part of Packt's Cookbook series-each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible

Book Details

Language : English
Paperback : 252 pages [ 235mm x 191mm ]
Release Date : June 2010
ISBN : 1849680345
ISBN 13 : 9781849680349
Author(s) : Abhishek Sanghani
Topics and Technologies : All Books, Enterprise Products and Platforms, Enterprise, IBM

Table of Contents

Chapter 1: Report Authoring Basic Concepts
Chapter 2: Advanced Report Authoring
Chapter 3: Tips and Tricks: JavaScripts
Chapter 4: Tips and Tricks: Report Page
Chapter 5: XML Editing
Chapter 6: Writing Printable Reports
Chapter 7: Working with Dimensional Models
Chapter 8: Macros
Chapter 9: Using Report Studio Better
Chapter 10: Some More Useful Recipes
Chapter 11: Best Practices
Appendix: Recommendations and References
  • Chapter 1: Report Authoring Basic Concepts
    • Introduction
    • Summary filter and detail filter
    • Sorting grouped values
    • Aggregation and rollup aggregation
    • Implementing IF THEN ELSE in filters
    • Data formatting options: Dates, numbers, and percentages
    • Creating sections
    • Hiding column in crosstab
    • Prompts: Display value versus use value
  • Chapter 2: Advanced Report Authoring
    • Introduction
    • Adding a cascaded prompt
    • Creating nested report: Defining master detail relationship
    • Writing back to the database
    • Adding conditional formatting
    • Running difference: Negative values in brackets and red
    • New conditional styling with v8.3 onwards
    • Conditional block: Many reports in one
    • Drill-through from crosstab intersection
    • Overriding crosstab intersection drill-through definition
  • Chapter 3: Tips and Tricks: JavaScripts
    • Introduction
    • Dynamic default value for prompt
    • Changing title of the dropdown box
    • Listbox: Applying Deselect All on rerun
    • Validating textbox prompts
    • Show/Hide prompt controls at runtime
    • Automatic selection and submission of values
    • Manipulating Date Time control
    • Variable width bar chart using JavaScript
  • Chapter 4: Tips and Tricks: Report Page
    • Introduction
    • Showing images dynamically (Traffic Light report)
    • Handling missing image issue
    • Dynamic links to external website (Google Map example)
    • Alternating drill link
    • Showing tool tip on reports
    • Achieving minimum column width
    • Merged cells in Excel output
    • Worksheet name in Excel output
    • Conditional column titles
  • Chapter 5: XML Editing
    • Introduction
    • Quickly changing drill targets
    • Copy-pasting drill link
    • Removing references to old package and namespaces
    • A hidden gem in XML—row level formatting
  • Chapter 6: Writing Printable Reports
    • Introduction
    • Container size and rows per page
    • Eliminating orphan rows
    • Defining page orientation and size (also override for one page)
    • Avoiding page title repetition
    • Horizontal pagination
    • Choosing output format from prompt
    • Choosing right colors
    • Defining page set
    • Caution about HTML items and JavaScript
  • Chapter 7: Working with Dimensional Models
    • Introduction
    • List report or crosstab report
    • Filtering rows or columns
    • Filtering whole report
    • Adding prompt into slicer and its limitation
    • New feature for zero suppression
    • Level independent MUN for parent child hierarchy
    • Aggregation versus pre-aggregated values
    • RoleValue() function
    • Swapping dimensions using string manipulation
  • Chapter 8: Macros
    • Introduction
    • Add data level security using CSVIdentityMap macro
    • Using prompt macro in native SQL
    • Making prompt optional
    • Adding token using macro
    • Using prompt and promptmany macros in query subject
    • Showing the prompt values in report based on security
    • String operations to get it right
    • Showing user name in footer
  • Chapter 9: Using Report Studio Better
    • Introduction
    • Report Studio environmental options
    • Copy-pasting partial or full report
    • Copy-pasting whole reports—8.2 to 8.4 possible
    • Setting execution time out
    • Setting maximum rows limit
    • Handle slow report validation
    • Capturing query
    • Browsing values from data expression window
    • Page structure view
    • Pick-up and apply style
    • Grab them all practice
  • Chapter 10: Some More Useful Recipes
    • Introduction
    • Timing report execution
    • Missing value versus zero value
    • Over-riding data formatting defined in database
    • Conditional drill-through
    • Dynamically switching reports using iFrame
  • Chapter 11: Best Practices
    • Introduction
    • Reducing number of query items
    • Highlighting hidden items
    • Relative path for images
    • Taming the JavaScripts
    • Customize classes for report-wide effect
    • Creating templates
    • Regression testing
    • Code comments
  • Appendix: Recommendations and References
    • Introduction
    • Version controlling
    • Recommendation for prompt types
    • Cognos Mashup Service
    • Third-party tools for Cognos
    • Express Authoring Mode
    • CAFE
    • Cognos Go Office

Abhishek Sanghani

Abhishek Sanghani was born in India and attended Mumbai University, where he majored in Computer Engineering. He began his career in 2004 as a Business Intelligence and Cognos Consultant, and has worked with leading IT and financial services companies since then. He pursued Finance Management along with his work in the field of Cognos and BI, successfully progressing and winning awards and certifications year-on-year. Presently, he is working in the United Kingdom, utilizing his skills of Cognos, SQL, BI, and data warehousing. In his free time, he writes technical blogs and also provides training/seminars on demand. He first authored Packt Publishing's book IBM Cognos 8 Report Studio Cookbook, which was well received worldwide. He has recently composed a video course called IBM Cognos 10 Report Studio Fundamentals, which is available on the website for download as well as online streaming.
Sorry, we don't have any reviews for this title yet.

Code Downloads

Download the code and support files for this book.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

IBM Cognos 8 Report Studio Cookbook +    Governance, Risk, and Compliance Handbook for Oracle Applications =
50% Off
the second eBook
Price for both: £35.30

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • Learn basic and advanced options around sorting, filtering, and aggregation of data
  • Explore the powerful features of Report Studio—Conditional Formatting, Cascaded Prompts, Master-Detailed queries, and more
  • Achieve real business demands such as dynamic drill-though links, showing tooltips, minimum column width, prompt manipulation, and merged cells
  • Learn to edit reports outside Report Studio using XML editing
  • Develop sophisticated printer friendly reports
  • Overcome tool limitations such as row level formatting, timing report execution, handling missing images, and so on
  • Learn tips on report development time
  • Introduce best practices such as inserting comments, regression testing, and version controlling in your reports
  • Enhance the features of Report Studio by using macros
  • Work with dimensional models (DMRs and Cubes)

In Detail

Cognos Report Studio is widely used for creating and managing business reports in medium to large companies. It is simple enough for any business analyst, power user, or developer to pick up and start developing basic reports. However, when it comes to developing more sophisticated, fully functional business reports for wider audiences, report authors will need guidance.

This book helps you understand and use all the features provided by Report Studio to generate impressive deliverables. It will take you from being a beginner to a professional report author. It bridges the gap between basic training provided by manuals or trainers and the practical techniques learned over years of practice.

This book covers all the basic and advanced features of Report Authoring. It begins by bringing readers on the same platform and introducing the fundamental features useful across any level of reporting. Then it ascends to advanced techniques and tricks to overcome Studio limitations.Develop excellent reports using dimensional data sources by following best practices that development work requires in Report Studio. You will also learn about editing the report outside the Studio by directly editing the XML specifications.

Provide richness to the user interface by adding JavaScript and HTML tags. The main focus is on the practical use of various powerful features that Report Studio has to offer to suit your business requirements.

Learn techniques and hacks to make the best out of your Cognos 8 Report Studio


Written in cookbook style, this book offers learning and techniques through recipes. It contains step-by-step instructions for Report Studio 8 users to author effective reports. The book is designed in such a way that you can refer to things chapter by chapter, and read them in no particular order.
You will see a new fictional business case in each recipe that will relate to a real-life problem and then you will learn how to crack it in Report Studio.

Who this book is for

If you are a Business Intelligence or MIS Developer (programmer) working on Cognos Report Studio who wants to author impressive reports by putting to use what this tool has to offer, this book is for you. You could also be a Business Analyst or Power User who authors his own reports and wants to look beyond the conventional features of Report Studio 8.

This book assumes that you can do basic authoring, are aware of the Cognos architecture, and are familiar with Studio.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software