Free Sample
+ Collection

IBM Cognos 8 Report Studio Cookbook

Cookbook
Abhishek Sanghani

Over 80 great recipes for taking control of IBM Cognos 8 Report Studio with this book and eBook
$35.99
$59.99
RRP $35.99
RRP $59.99
eBook
Print + eBook

Want this title & more?

$16.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849680349
Paperback252 pages

About This Book

 

  • 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

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.

Table of Contents

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

What You Will Learn

  • 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.

Authors

Read More