IBM Cognos 10 Report Studio Cookbook（Second Edition）

IBM Cognos Cloud

IBM Cognos Workspace Advanced

IBM Cognos Workspace

IBM Cognos for Microsoft Office

IBM Cognos Analysis For Excel (CAFE)

SDK and third-party tools for Cognos

Cognos Mashup Service

Recommendations for prompt types

Version controlling

Introduction

Appendix A. Recommendations and References

Enabling a larger worksheet size for Excel 2007

Naming data containers (lists crosstabs and charts) for use in Cognos Workspace

Commenting the code

Regression testing

Creating templates

Customizing classes for report-wide effect

Controlling JavaScript file execution

Using relative paths for images

Highlighting hidden items

Reducing the number of query items

Introduction

Chapter 13. Best Practices

Freezing column titles

Dynamically switching between reports using an iFrame

Setting up conditional drill-throughs

Overriding data formatting using patterns

Missing values versus zero values

Timing report execution

Introduction

Chapter 12. More Useful Recipes

Getting started with scatter charts

Getting started with bullet charts

Working with pie charts

Converting a chart to another chart type

Chart formatting options

Introduction

Chapter 11. Charts and New Chart Features

Filtering data using Data Check Box Group

Working with the Data Deck

Working with Decks

Building tabbed reports

Introduction

Chapter 10. Working with Active Reports

Using Default Data Formats

Using the "grab them all" practice

Picking up and applying styles

Viewing the page structure

Browsing values from the data expression window

Capturing a query

Handling slow report validation

Setting the maximum row limit

Setting the execution timeout

Upgrading report specifications

Copying and pasting partial or full reports

Using Report Studio's environmental options

Introduction

Chapter 9. Using Report Studio Efficiently

Showing a username in the footer

String operations to get it right

Showing the prompt values in a report based on security

Using the prompt() and promptmany() macros in query subjects

Adding a token using macros

Making prompts optional

Using the Prompt macro in native SQL

Adding data-level security using the CSVIdentityMap macro

Introduction

Chapter 8. Working with Macros

Swapping dimensions using MUN manipulation

The roleValue() function

Aggregation versus preaggregated values

Achieving zero suppression

Adding a prompt into Slicer and its limitations

Filtering a whole report

Filtering rows or columns

List report or crosstab report

Introduction

Chapter 7. Working with Dimensional Models

Displaying the report name in a footer

Cautions about HTML items and JavaScript files

Defining page sets

Choosing the right colors

Choosing the output format from a prompt

Page numbering with horizontal pagination

Horizontal pagination

Avoiding page title repetition

Defining page orientation and size (and overriding them for one page)

Eliminating orphan rows

Controlling the container size and rows per page

Introduction

Chapter 6. Writing Printable Reports

A hidden gem in XML – row level formatting

Removing references to old packages or items

Copying and pasting drill links

Changing drill targets quickly

Introduction

Chapter 5. Working with XML

Conditional column titles

Worksheet name in Excel output

Merged cells in Excel output

Showing tooltips on reports

Alternating drill links

Dynamic links to an external website (a Google Maps example)

Handling the missing image issue

Showing images dynamically (traffic light report)

Introduction

Chapter 4. The Report Page – Tips and Tricks

Creating a variable width bar chart using JavaScript

Manipulating the Date Time control

Selecting and submitting values automatically

Showing/hiding prompt controls at runtime

Validating textbox prompts

Changing the title of the value prompt

Defining dynamic default values for prompts

Introduction

Chapter 3. Using JavaScript Files – Tips and Tricks

Overriding crosstab intersection drill-through definitions

Defining drill-through from crosstab intersection

Using conditional blocks – many reports in one

Playing with conditional styles

Formatting negative values

Adding conditional formatting

Writing back to the database

Creating a nested report – defining the master-detail relationship

Adding cascaded prompts

Introduction

Chapter 2. Advanced Report Authoring

Prompts – display value versus use value

Hiding columns in crosstabs

Creating sections

Formatting data – dates numbers and percentages

Implementing if-then-else in filters

Aggregation and rollup aggregation

Sorting grouped values

Summary filters and detail filters

Introduction

Chapter 1. Report Authoring Basic Concepts

Preface

www.PacktPub.com

About the Reviewers

About the Authors

Credits

版权信息

封面

封面

版权信息

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Preface

Chapter 1. Report Authoring Basic Concepts

Introduction

Summary filters and detail filters

Sorting grouped values

Aggregation and rollup aggregation

Implementing if-then-else in filters

Formatting data – dates numbers and percentages

Creating sections

Hiding columns in crosstabs

Prompts – display value versus use value

Chapter 2. Advanced Report Authoring

Introduction

Adding cascaded prompts

Creating a nested report – defining the master-detail relationship

Writing back to the database

Adding conditional formatting

Formatting negative values

Playing with conditional styles

Using conditional blocks – many reports in one

Defining drill-through from crosstab intersection

Overriding crosstab intersection drill-through definitions

Chapter 3. Using JavaScript Files – Tips and Tricks

Introduction

Defining dynamic default values for prompts

Changing the title of the value prompt

Validating textbox prompts

Showing/hiding prompt controls at runtime

Selecting and submitting values automatically

Manipulating the Date Time control

Creating a variable width bar chart using JavaScript

Chapter 4. The Report Page – Tips and Tricks

Introduction

Showing images dynamically (traffic light report)

Handling the missing image issue

Dynamic links to an external website (a Google Maps example)

Alternating drill links

Showing tooltips on reports

Merged cells in Excel output

Worksheet name in Excel output

Conditional column titles

Chapter 5. Working with XML

Introduction

Changing drill targets quickly

Copying and pasting drill links

Removing references to old packages or items

A hidden gem in XML – row level formatting

Chapter 6. Writing Printable Reports

Introduction

Controlling the container size and rows per page

Eliminating orphan rows

Defining page orientation and size (and overriding them for one page)

Avoiding page title repetition

Horizontal pagination

Page numbering with horizontal pagination

Choosing the output format from a prompt

Choosing the right colors

Defining page sets

Cautions about HTML items and JavaScript files

Displaying the report name in a footer

Chapter 7. Working with Dimensional Models

Introduction

List report or crosstab report

Filtering rows or columns

Filtering a whole report

Adding a prompt into Slicer and its limitations

Achieving zero suppression

Aggregation versus preaggregated values

The roleValue() function

Swapping dimensions using MUN manipulation

Chapter 8. Working with Macros

Introduction

Adding data-level security using the CSVIdentityMap macro

Using the Prompt macro in native SQL

Making prompts optional

Adding a token using macros

Using the prompt() and promptmany() macros in query subjects

Showing the prompt values in a report based on security

String operations to get it right

Showing a username in the footer

Chapter 9. Using Report Studio Efficiently

Introduction

Using Report Studio's environmental options

Copying and pasting partial or full reports

Upgrading report specifications

Setting the execution timeout

Setting the maximum row limit

Handling slow report validation

Capturing a query

Browsing values from the data expression window

Viewing the page structure

Picking up and applying styles

Using the "grab them all" practice

Using Default Data Formats

Chapter 10. Working with Active Reports

Introduction

Building tabbed reports

Working with Decks

Working with the Data Deck

Filtering data using Data Check Box Group

Chapter 11. Charts and New Chart Features

Introduction

Chart formatting options

Converting a chart to another chart type

Working with pie charts

Getting started with bullet charts

Getting started with scatter charts

Chapter 12. More Useful Recipes

Introduction

Timing report execution

Missing values versus zero values

Overriding data formatting using patterns

Setting up conditional drill-throughs

Dynamically switching between reports using an iFrame

Freezing column titles

Chapter 13. Best Practices

Introduction

Reducing the number of query items

Highlighting hidden items

Using relative paths for images

Controlling JavaScript file execution

Customizing classes for report-wide effect

Creating templates

Regression testing

Commenting the code

Naming data containers (lists crosstabs and charts) for use in Cognos Workspace

Enabling a larger worksheet size for Excel 2007

Appendix A. Recommendations and References

Introduction

Version controlling

Recommendations for prompt types

Cognos Mashup Service

SDK and third-party tools for Cognos

IBM Cognos Analysis For Excel (CAFE)

IBM Cognos for Microsoft Office

IBM Cognos Workspace

IBM Cognos Workspace Advanced

IBM Cognos Cloud