book

IBM Cognos 8 Report Studio Cookbook

Name: IBM Cognos 8 Report Studio Cookbook
Author: Abhishek Sanghani
ISBN: 9781849680349

by Abhishek Sanghani

June 2010

Intermediate to advanced

272 pages

5h 55m

English

Packt Publishing

Read now

Unlock full access

IBM Cognos 8 Report Studio Cookbook
Table of Contents
IBM Cognos 8 Report Studio Cookbook
Credits
About the Author
About the Reviewers
Preface
What this book covers
What you need for this book
Who this book is for
Conventions

Reader feedback
Customer support
ErrataPiracyQuestions
1. Report Authoring Basic Concepts
Introduction
Summary filter and detail filter
Getting readyHow to do it...How it works...Detail filterSummary filterThere's more...Before/After aggregationSee also
Sorting grouped values
Getting readyHow to do it...How it works...There's more...
Aggregation and rollup aggregation
Getting readyHow to do it...How it works...Aggregation propertyRollup aggregationMultiple aggregationsThere's more...
Implementing IF THEN ELSE in filters
Getting readyHow to do it...How it works...There's more...
Data formatting options: Dates, numbers, and percentages
Getting readyHow to do it...How it works...CAST functionNumerical format% MarginThere's more...
Creating sections
Getting readyHow to do it...How it works...There's more...See also
Hiding column in crosstab
Getting readyHow to do it...How it works...There's more...
Prompts: Display value versus use value
Getting readyHow to do it...How it works...There's more...
2. Advanced Report Authoring
Introduction
Adding a cascaded prompt
Getting readyHow to do it...How it works...Cascaded sourceThere's more...Auto submitMore infoSee also
Creating nested report: Defining master detail relationship
Getting readyHow to do it...How it works...Master Detail relationshipThere's more...See also
Writing back to the database
Getting readyHow to do it...How it works...There's more...
Adding conditional formatting
Getting readyHow to do it...How it works...String variableBoolean variableReport language variableThere's more...Style variable propertyText source variable property
Running difference: Negative values in brackets and red
Getting readyHow to do it...How it works...Running differenceShowing negative values in red and brackets
New conditional styling with v8.3 onwards
Getting readyHow to do it...How it works...There's more...
Conditional block: Many reports in one
Getting readyHow to do it...How it works...There's more...
Drill-through from crosstab intersection
Getting readyHow to do it...How it works...
Overriding crosstab intersection drill-through definition
Getting readyHow to do it...How it works...There's more...
3. Tips and Tricks: JavaScripts
Introduction
Dynamic default value for prompt
Getting readyHow to do it...How it works...SPANGetElementsByTagNameSelectedIndexCanSubmitPromptThere's more...
Changing title of the dropdown box
Getting readyHow to do it...How it works...There's more...
Listbox: Applying Deselect All on rerun
Getting readyHow to do it...How it works...There's more...
Validating textbox prompts
Getting readyHow to do it...How it works...
Show/Hide prompt controls at runtime
Getting readyHow to do it...How it works...There's more...More Info
Automatic selection and submission of values
Getting readyHow to do it...How it works...There's more...
Manipulating Date Time control
Getting readyHow to do it...How it works...There's more...See also
Variable width bar chart using JavaScript
Getting readyHow to do it...How it works...There's more...
4. Tips and Tricks: Report Page
Introduction
Showing images dynamically (Traffic Light report)
Getting readyHow it works...There's more...More info
Handling missing image issue
Getting readyHow to do it...How it works...There's more...
Dynamic links to external website (Google Map example)
Getting readyHow to do it...How it works...There's more...
Alternating drill link
Getting readyHow to do it...How it works...Render variableThere's more...
Showing tool tip on reports
Getting readyHow to do it...How it works...There's more...See also
Achieving minimum column width
Getting readyHow to do it...How it works...
Merged cells in Excel output
Getting readyHow to do it...How it works...
Worksheet name in Excel output
Getting readyHow to do it...How it works...There's more...
Conditional column titles
Getting readyHow to do it...How it works...
5. XML Editing
Introduction
Quickly changing drill targets
Getting readyHow to do it...How it works...There's more...
Copy-pasting drill link
Getting readyHow to do it...How it works...There's more...
Removing references to old package and namespaces
Getting readyHow to do it...How it works...
A hidden gem in XML—row level formatting
Getting readyHow to do it...How it works...There's more...See also
6. Writing Printable Reports
Introduction
Container size and rows per page
Getting readyHow to do it...How it works...There's more...
Eliminating orphan rows
Getting readyHow to do it...How it works...There's more...
Defining page orientation and size (also override for one page)
Getting readyHow to do it...How it works...
Avoiding page title repetition
Getting readyHow to do it...How it works...There's more...
Horizontal pagination
Getting readyHow to do it...How it works...There's more...
Choosing output format from prompt
Getting readyHow to do it...How it works...There's more...
Choosing right colors
Getting readyHow to do it...How it works...There's more...
Defining page set
Getting readyHow to do it...How it works...
Caution about HTML items and JavaScript
Getting readyHow to do it...How it works...
7. Working with Dimensional Models
Introduction
List report or crosstab report
Getting readyHow to do it...How it works...
Filtering rows or columns
Getting readyHow to do it...How it works...There's more...
Filtering whole report
Getting readyHow to do it...How it works...There's more...
Adding prompt into slicer and its limitation
Getting readyHow to do it...How it works...There's more...More Info
New feature for zero suppression
Getting readyHow to do it...How it works...There's more...
Level independent MUN for parent child hierarchy
Getting readyHow to do it...How it works...
Aggregation versus pre-aggregated values
Getting readyHow to do it...How it works...There's more...
RoleValue() function
Getting readyHow to do it...How it works...
Swapping dimensions using string manipulation
Getting readyHow to do it...How it works...See also
8. Macros
Introduction
Add data level security using CSVIdentityMap macro
Getting readyHow to do it...How it works...There's more...
Using prompt macro in native SQL
Getting readyHow to do it...How it works...There's more...
Making prompt optional
Getting readyHow to do it...How it works...Optional_defaultValuePure_OptionalThere's more...
Adding token using macro
Getting readyHow to do it...How it works...
Using prompt and promptmany macros in query subject
Getting readyHow to do it...How it works...
Showing the prompt values in report based on security
Getting readyHow to do it...How it works...
String operations to get it right
Getting readyHow to do it...How it works...There's more...
Showing user name in footer
Getting readyHow to do it...How it works...There's more...
9. Using Report Studio Better
Introduction
Report Studio environmental options
Getting readyHow to do it...How it works...View | Visual AidStructure | Crosstab Node Creation OptionTools | Options | View | Reuse Cognos Viewer WindowTools | Options | Report OptionsThere's more...
Copy-pasting partial or full report
Getting readyHow to do it...How it works...
Copy-pasting whole reports—8.2 to 8.4 possible
Getting readyHow to do it...How it works...
Setting execution time out
Getting readyHow to do it...How it works...There's more...
Setting maximum rows limit
Getting readyHow to do it...How it works...
Handle slow report validation
Getting readyHow to do it...How it works...There's more...
Capturing query
Getting readyHow to do it...How it works...Why make filters mandatory?Query formattingCapture the query for database
Browsing values from data expression window
Getting readyHow to do it...How it works...There's more...
Page structure view
Getting readyHow to do it...How it works...
Pick-up and apply style
Getting readyHow to do it...How it works...
Grab them all practice
Getting readyHow to do it...How it works...There's more…
10. Some More Useful Recipes
Introduction
Timing report execution
Getting readyHow to do it...How it works...Report viewSchedulingThere's more...
Missing value versus zero value
Getting readyHow to do it...How it works...There's more...
Over-riding data formatting defined in database
Getting readyHow to do it...How it works...
Conditional drill-through
Getting readyHow to do it...How it works...There's more...
Dynamically switching reports using iFrame
Getting readyHow to do it...How it works...There's more...
11. Best Practices
Introduction
Reducing number of query items
Getting readyHow to do it...How it works...Alias member unique nameDelete unreferenced query objectsDragging items from data items pane
Highlighting hidden items
Getting readyHow to do it...How it works...
Relative path for images
Getting readyHow to do it...How it works...There's more...
Taming the JavaScripts
Getting readyHow to do it...How it works...
Customize classes for report-wide effect
Getting readyHow to do it...How it works...
Creating templates
Getting readyHow to do it...How it works...
Regression testing
Getting readyHow to do it...How it works...There's more...
Code comments
Getting readyHow to do it...How it works...
A. 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
Index

Content preview from IBM Cognos 8 Report Studio Cookbook

Aggregation and rollup aggregation

Business owners want to see the unit cost of every product. They also want the entries to be grouped by product line and see the highest unit cost for each product line. At the end of the report, they want to see the average unit cost for the whole range.

Getting ready

Create a simple list report with Product | Product line, Product | Product name and Sales Fact | Unit Cost as columns.

How to do it...

We will start by examining the Unit Cost column. Click on this column and check the Aggregate Function property.
Set this property to Average.
Add grouping for Product line and Product names, by selecting those columns and hitting the GROUP button from toolbar.
Click on the Unit Cost column and click on the Aggregate ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

IBM Cognos 10 Report Studio Cookbook - Second Edition

Publisher Resources

ISBN: 9781849680349Other

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design