IBM Cognos 10 Report Studio Cookbook. Getting the most out of IBM Cognos Report Studio is a breeze with this recipe-packed cookbook. Cherry-pick the o

IBM Cognos 10 Report Studio Cookbook. Getting the most out of IBM Cognos Report Studio is a breeze with this recipe-packed cookbook. Cherry-pick the o - Opis

IBM 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, this book is designed to take the reader beyond the basics and into the world of creating more sophisticated, functional business reports.IBM Cognos 10 Report Studio Cookbook, Second Edition 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.Written in a recipe style, this book offers step-by-step instructions for IBM Cognos Report Studio users to author reports effectively, allowing a reader to dip in and out of the chapters as they desire.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.This book covers all the basic and advanced features of Report Authoring. It introduces 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. You will discover (...) więcej how to build and use Cognos Active Reports, a new addition in IBM Cognos 10.Provide richness to the user interface by adding JavaScript and HTML tags and using the different chart types introduced in IBM Cognos 10. The main focus is on the practical use of various powerful features that Report Studio has to offer to suit your business requirements.Learn numerous techniques and hacks that will allow you to make the best out of your IBM Cognos 10 Report Studio. Spis treści:
IBM Cognos 10 Report Studio Cookbook Second Edition
Table of Contents
IBM Cognos 10 Report Studio Cookbook Second Edition
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers and more
Why Subscribe?
Free Access for Packt account holders
Instant Updates on New Packt Books
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 filters and detail filters
Getting ready
How to do it...
How it works...
The detail filter
The summary filter
Theres 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...
The aggregation property
The rollup aggregation property
Multiple aggregation
There's more...
Implementing if-then-else in filters
Getting ready
How to do it...
How it works...
There's more...
Formatting data dates, numbers, and percentages
Getting ready
How to do it...
How it works...
Date format
Numerical format
The % margin
There's more...
Creating sections
Getting ready
How to do it...
How it works...
There's more...
See also
Hiding columns in crosstabs
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 cascaded prompts
Getting ready
How to do it...
How it works...
Cascaded source
There's more...
Auto-Submit
See also
Creating a nested report defining the master-detail relationship
Getting ready
How to do it...
How it works...
The 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...
The String variable
The Boolean variable
The report language variable
There's more...
The style variable property
The text source variable property
Formatting negative values
Getting ready
How to do it...
How it works...
Running Difference
Showing negative values in red and brackets
Playing with conditional styles
Getting ready
How to do it...
How it works...
There's more...
Using conditional blocks many reports in one
Getting ready
How to do it...
How it works...
There's more...
Defining drill-through from crosstab intersection
Getting ready
How to do it...
How it works...
Overriding crosstab intersection drill-through definitions
Getting ready
How to do it...
How it works...
There's more...
3. Using JavaScript Files Tips and Tricks
Introduction
Defining dynamic default values for prompts
Getting ready
How to do it...
How it works...
Span
GetElementsByTagName
SelectedIndex
CanSubmitPrompt
There's more...
Changing the title of the value prompt
Getting ready
How to do it...
How it works...
There's more...
Validating textbox prompts
Getting ready
How to do it...
How it works...
Showing/hiding prompt controls at runtime
Getting ready
How to do it...
How it works...
There's more...
Selecting and submitting values automatically
Getting ready
How to do it...
How it works...
There's more...
Manipulating the Date Time control
Getting ready
How to do it...
How it works...
There's more...
Creating a variable width bar chart using JavaScript
Getting ready
How to do it...
How it works...
There's more...
4. The Report Page Tips and Tricks
Introduction
Showing images dynamically (traffic light report)
Getting ready
How to do it...
How it works...
There's more...
Handling the missing image issue
Getting ready
How to do it...
How it works...
There's more...
Dynamic links to an external website (a Google Maps example)
Getting ready
How to do it...
How it works...
There's more...
Alternating drill links
Getting ready
How to do it...
How it works...
Render Variable
There's more...
Showing tooltips on reports
Getting ready
How to do it...
How it works...
There's more...
See also
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. Working with XML
Introduction
Changing drill targets quickly
Getting ready
How to do it...
How it works...
There's more...
Copying and pasting drill links
Getting ready
How to do it...
How it works...
There's more...
Removing references to old packages or items
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
Controlling the 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 (and overriding them 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...
Page numbering with horizontal pagination
Getting ready
How to do it...
How it works...
Choosing the output format from a prompt
Getting ready
How to do it...
How it works...
There's more...
Choosing the right colors
Getting ready
How to do it...
How it works...
There's more...
Defining page sets
Getting ready
How to do it...
How it works...
Cautions about HTML items and JavaScript files
Getting ready
How to do it...
How it works...
Displaying the report name in a footer
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 a whole report
Getting ready
How to do it...
How it works...
There's more...
Adding a prompt into Slicer and its limitations
Getting ready
How to do it...
How it works...
There's more...
More Info
Achieving zero suppression
Getting ready
How to do it...
How it works...
There's more...
Aggregation versus preaggregated values
Getting ready
How to do it...
How it works...
There's more...
The roleValue() function
Getting ready
How to do it...
How it works...
There's more...
Swapping dimensions using MUN manipulation
Getting ready
How to do it...
How it works...
See also
8. Working with Macros
Introduction
Adding data-level security using the CSVIdentityMap macro
Getting ready
How to do it...
How it works...
There's more...
Using the Prompt macro in native SQL
Getting ready
How to do it...
How it works...
There's more...
Making prompts optional
Getting ready
How to do it...
How it works...
Optional_defaultValue
Pure_Optional
There's more...
Adding a token using macros
Getting ready
How to do it...
How it works...
Using the prompt() and promptmany() macros in query subjects
Getting ready
How to do it...
How it works...
Showing the prompt values in a 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 a username in the footer
Getting ready
How to do it...
How it works...
There's more...
9. Using Report Studio Efficiently
Introduction
Using Report Studio's environmental options
Getting ready
How to do it...
How it works...
View | Visual Aids
Structure | Create Crosstab Nodes
Tools | Options | View | Reuse IBM Cognos Viewer window
Tools | Options | Report
There's more...
Copying and pasting partial or full reports
Getting ready
How to do it...
How it works...
Upgrading report specifications
Getting ready
How to do it...
How it works...
Setting the execution timeout
Getting ready
How to do it...
How it works...
There's more...
Setting the maximum row limit
Getting ready
How to do it...
How it works...
Handling slow report validation
Getting ready
How to do it...
How it works...
There's more...
Capturing a query
Getting ready
How to do it...
How it works...
There's more
Why make filters mandatory?
Query formatting
Capturing the query for the database
Browsing values from the data expression window
Getting ready
How to do it...
How it works...
There's more...
Viewing the page structure
Getting ready
How to do it...
How it works...
Picking up and applying styles
Getting ready
How to do it...
How it works...
Using the "grab them all" practice
Getting ready
How to do it...
How it works...
See also
Using Default Data Formats
Getting ready
How to do it...
How it works...
10. Working with Active Reports
Introduction
Building tabbed reports
Getting ready
How to do it...
How it works...
There's more...
Working with Decks
Getting ready
How to do it...
How it works...
There's more...
Working with the Data Deck
Getting ready
How to do it...
How it works...
Filtering data using Data Check Box Group
Getting ready
How to do it...
How it works...
There's more...
11. Charts and New Chart Features
Introduction
Chart formatting options
Getting ready
How to do it...
How it works...
Chart Palette Presets
Background Effects Presets
There's more...
Converting a chart to another chart type
Getting ready
How to do it...
How it works...
Working with pie charts
Getting ready
How to do it...
How it works...
The Summarize Small Slices property
The First Slice Angle property
The Exploded Slices property
Getting started with bullet charts
Getting ready
How to do it...
How it works...
There's more...
Getting started with scatter charts
Getting ready
How to do it...
How it works...
12. More Useful Recipes
Introduction
Timing report execution
Getting ready
How to do it...
How it works...
The report view
Scheduling
There's more...
Missing values versus zero values
Getting ready
How to do it...
How it works...
There's more...
Overriding data formatting using patterns
Getting ready
How to do it...
How it works...
Setting up conditional drill-throughs
Getting ready
How to do it...
How it works...
There's more...
Dynamically switching between reports using an iFrame
Getting ready
How to do it...
How it works...
There's more...
Freezing column titles
Getting ready
How to do it...
How it works...
There's more...
13. Best Practices
Introduction
Reducing the number of query items
Getting ready
How to do it...
How it works...
Alias member unique name
Delete unreferenced query objects
Dragging items from the Data Items pane
Highlighting hidden items
Getting ready
How to do it...
How it works...
Using relative paths for images
Getting ready
How to do it...
How it works...
There's more...
Controlling JavaScript file execution
Getting ready
How to do it...
How it works...
Customizing 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...
Commenting the code
Getting ready
How to do it...
How it works...
Naming data containers (lists, crosstabs, and charts) for use in Cognos Workspace
Getting ready
How to do it...
How it works...
There's more...
Enabling a larger worksheet size for Excel 2007
Getting ready
How to do it...
How it works...
There's more...
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
Index mniej