IBM Cognos 8 Report Studio Cookbook电子书

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

Errata

Piracy

Questions

1. Report Authoring Basic Concepts

Introduction

Summary filter and detail filter

Getting ready

How to do it...

How it works...

Detail filter

Summary filter

There's more...

Before/After aggregation

See also

Sorting grouped values

Getting ready

How to do it...

How it works...

There's more...

Aggregation and rollup aggregation

Getting ready

How to do it...

How it works...

Aggregation property

Rollup aggregation

Multiple aggregations

There's more...

Implementing IF THEN ELSE in filters

Getting ready

How to do it...

How it works...

There's more...

Data formatting options: Dates, numbers, and percentages

Getting ready

How to do it...

How it works...

CAST function

Numerical format

% Margin

There's more...

Creating sections

Getting ready

How to do it...

How it works...

There's more...

See also

Hiding column in crosstab

Getting ready

How to do it...

How it works...

There's more...

Prompts: Display value versus use value

Getting ready

How to do it...

How it works...

There's more...

2. Advanced Report Authoring

Introduction

Adding a cascaded prompt

Getting ready

How to do it...

How it works...

Cascaded source

There's more...

Auto submit

More info

See also

Creating nested report: Defining master detail relationship

Getting ready

How to do it...

How it works...

Master Detail relationship

There's more...

See also

Writing back to the database

Getting ready

How to do it...

How it works...

There's more...

Adding conditional formatting

Getting ready

How to do it...

How it works...

String variable

Boolean variable

Report language variable

There's more...

Style variable property

Text source variable property

Running difference: Negative values in brackets and red

Getting ready

How to do it...

How it works...

Running difference

Showing negative values in red and brackets

New conditional styling with v8.3 onwards

Getting ready

How to do it...

How it works...

There's more...

Conditional block: Many reports in one

Getting ready

How to do it...

How it works...

There's more...

Drill-through from crosstab intersection

Getting ready

How to do it...

How it works...

Overriding crosstab intersection drill-through definition

Getting ready

How to do it...

How it works...

There's more...

3. Tips and Tricks: JavaScripts

Introduction

Dynamic default value for prompt

Getting ready

How to do it...

How it works...

SPAN

GetElementsByTagName

SelectedIndex

CanSubmitPrompt

There's more...

Changing title of the dropdown box

Getting ready

How to do it...

How it works...

There's more...

Listbox: Applying Deselect All on rerun

Getting ready

How to do it...

How it works...

There's more...

Validating textbox prompts

Getting ready

How to do it...

How it works...

Show/Hide prompt controls at runtime

Getting ready

How to do it...

How it works...

There's more...

More Info

Automatic selection and submission of values

Getting ready

How to do it...

How it works...

There's more...

Manipulating Date Time control

Getting ready

How to do it...

How it works...

There's more...

See also

Variable width bar chart using JavaScript

Getting ready

How to do it...

How it works...

There's more...

4. Tips and Tricks: Report Page

Introduction

Showing images dynamically (Traffic Light report)

Getting ready

How it works...

There's more...

More info

Handling missing image issue

Getting ready

How to do it...

How it works...

There's more...

Dynamic links to external website (Google Map example)

Getting ready

How to do it...

How it works...

There's more...

Alternating drill link

Getting ready

How to do it...

How it works...

Render variable

There's more...

Showing tool tip on reports

Getting ready

How to do it...

How it works...

There's more...

See also

Achieving minimum column width

Getting ready

How to do it...

How it works...

Merged cells in Excel output

Getting ready

How to do it...

How it works...

Worksheet name in Excel output

Getting ready

How to do it...

How it works...

There's more...

Conditional column titles

Getting ready

How to do it...

How it works...

5. XML Editing

Introduction

Quickly changing drill targets

Getting ready

How to do it...

How it works...

There's more...

Copy-pasting drill link

Getting ready

How to do it...

How it works...

There's more...

Removing references to old package and namespaces

Getting ready

How to do it...

How it works...

A hidden gem in XML—row level formatting

Getting ready

How to do it...

How it works...

There's more...

See also

6. Writing Printable Reports

Introduction

Container size and rows per page

Getting ready

How to do it...

How it works...

There's more...

Eliminating orphan rows

Getting ready

How to do it...

How it works...

There's more...

Defining page orientation and size (also override for one page)

Getting ready

How to do it...

How it works...

Avoiding page title repetition

Getting ready

How to do it...

How it works...

There's more...

Horizontal pagination

Getting ready

How to do it...

How it works...

There's more...

Choosing output format from prompt

Getting ready

How to do it...

How it works...

There's more...

Choosing right colors

Getting ready

How to do it...

How it works...

There's more...

Defining page set

Getting ready

How to do it...

How it works...

Caution about HTML items and JavaScript

Getting ready

How to do it...

How it works...

7. Working with Dimensional Models

Introduction

List report or crosstab report

Getting ready

How to do it...

How it works...

Filtering rows or columns

Getting ready

How to do it...

How it works...

There's more...

Filtering whole report

Getting ready

How to do it...

How it works...

There's more...

Adding prompt into slicer and its limitation

Getting ready

How to do it...

How it works...

There's more...

More Info

New feature for zero suppression

Getting ready

How to do it...

How it works...

There's more...

Level independent MUN for parent child hierarchy

Getting ready

How to do it...

How it works...

Aggregation versus pre-aggregated values

Getting ready

How to do it...

How it works...

There's more...

RoleValue() function

Getting ready

How to do it...

How it works...

Swapping dimensions using string manipulation

Getting ready

How to do it...

How it works...

See also

8. Macros

Introduction

Add data level security using CSVIdentityMap macro

Getting ready

How to do it...

How it works...

There's more...

Using prompt macro in native SQL

Getting ready

How to do it...

How it works...

There's more...

Making prompt optional

Getting ready

How to do it...

How it works...

Optional_defaultValue

Pure_Optional

There's more...

Adding token using macro

Getting ready

How to do it...

How it works...

Using prompt and promptmany macros in query subject

Getting ready

How to do it...

How it works...

Showing the prompt values in report based on security

Getting ready

How to do it...

How it works...

String operations to get it right

Getting ready

How to do it...

How it works...

There's more...

Showing user name in footer

Getting ready

How to do it...

How it works...

There's more...

9. Using Report Studio Better

Introduction

Report Studio environmental options

Getting ready

How to do it...

How it works...

View | Visual Aid

Structure | Crosstab Node Creation Option

Tools | Options | View | Reuse Cognos Viewer Window

Tools | Options | Report Options

There's more...

Copy-pasting partial or full report

Getting ready

How to do it...

How it works...

Copy-pasting whole reports—8.2 to 8.4 possible

Getting ready

How to do it...

How it works...

Setting execution time out

Getting ready

How to do it...

How it works...

There's more...

Setting maximum rows limit

Getting ready

How to do it...

How it works...

Handle slow report validation

Getting ready

How to do it...

How it works...

There's more...

Capturing query

Getting ready

How to do it...

How it works...

Why make filters mandatory?

Query formatting

Capture the query for database

Browsing values from data expression window

Getting ready

How to do it...

How it works...

There's more...

Page structure view

Getting ready

How to do it...

How it works...

Pick-up and apply style

Getting ready

How to do it...

How it works...

Grab them all practice

Getting ready

How to do it...

How it works...

There's more…

10. Some More Useful Recipes

Introduction

Timing report execution

Getting ready

How to do it...

How it works...

Report view

Scheduling

There's more...

Missing value versus zero value

Getting ready

How to do it...

How it works...

There's more...

Over-riding data formatting defined in database

Getting ready

How to do it...

How it works...

Conditional drill-through

Getting ready

How to do it...

How it works...

There's more...

Dynamically switching reports using iFrame

Getting ready

How to do it...

How it works...

There's more...

11. Best Practices

Introduction

Reducing number of query items

Getting ready

How to do it...

How it works...

Alias member unique name

Delete unreferenced query objects

Dragging items from data items pane

Highlighting hidden items

Getting ready

How to do it...

How it works...

Relative path for images

Getting ready

How to do it...

How it works...

There's more...

Taming the JavaScripts

Getting ready

How to do it...

How it works...

Customize classes for report-wide effect

Getting ready

How to do it...

How it works...

Creating templates

Getting ready

How to do it...

How it works...

Regression testing

Getting ready

How to do it...

How it works...

There's more...

Code comments

Getting ready

How 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