| Description |
1 online resource (364 pages) |
| Contents |
Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; 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 databaseAdding 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 JavaScriptChapter 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 ReportsIntroduction; 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 reportAdding 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 |
| Summary |
This Cookbook contains step-by-step instructions for Report Studio 10.1 users to author effective reports. The book is designed in a way that you can refer to it chapter by chapter, look at the list of recipes and read them in no particular order. The Cognos 10.1 Report Studio Cookbook is for you if you are a Business Intelligence Developer who is working on IBM Cognos 10 Report Studio and wants to author impressive reports by putting to use what this tool has to offer. It is also ideal you are a Business Analyst or Power User who authors his own reports and wants to look beyond the conventiona |
| Notes |
Print version record |
| Subject |
Business report writing -- Computer programs
|
|
Database management -- Computer programs.
|
|
Database Management Systems
|
|
Business report writing -- Computer programs
|
|
Database management -- Computer programs
|
| Form |
Electronic book
|
| ISBN |
9781849688215 |
|
1849688214 |
|
