- IBM Cognos 8 Report Studio Cookbook
- Table of Contents
- IBM Cognos 8 Report Studio Cookbook
- Credits
- About the Author
- About the Reviewers
- Preface
- 1. Report Authoring Basic Concepts
- 2. Advanced Report Authoring
- Introduction
- Adding a cascaded prompt
- Creating nested report: Defining master detail relationship
- Writing back to the database
- Adding conditional formatting
- Running difference: Negative values in brackets and red
- New conditional styling with v8.3 onwards
- Conditional block: Many reports in one
- Drill-through from crosstab intersection
- Overriding crosstab intersection drill-through definition
- 3. Tips and Tricks: JavaScripts
- Introduction
- Dynamic default value for prompt
- Changing title of the dropdown box
- Listbox: Applying Deselect All on rerun
- Validating textbox prompts
- Show/Hide prompt controls at runtime
- Automatic selection and submission of values
- Manipulating Date Time control
- Variable width bar chart using JavaScript
- 4. Tips and Tricks: Report Page
- Introduction
- Showing images dynamically (Traffic Light report)
- Handling missing image issue
- Dynamic links to external website (Google Map example)
- Alternating drill link
- Showing tool tip on reports
- Achieving minimum column width
- Merged cells in Excel output
- Worksheet name in Excel output
- Conditional column titles
- 5. XML Editing
- 6. Writing Printable Reports
- Introduction
- Container size and rows per page
- Eliminating orphan rows
- Defining page orientation and size (also override for one page)
- Avoiding page title repetition
- Horizontal pagination
- Choosing output format from prompt
- Choosing right colors
- Defining page set
- Caution about HTML items and JavaScript
- 7. Working with Dimensional Models
- Introduction
- List report or crosstab report
- Filtering rows or columns
- Filtering whole report
- Adding prompt into slicer and its limitation
- New feature for zero suppression
- Level independent MUN for parent child hierarchy
- Aggregation versus pre-aggregated values
- RoleValue() function
- Swapping dimensions using string manipulation
- 8. Macros
- Introduction
- Add data level security using CSVIdentityMap macro
- Using prompt macro in native SQL
- Making prompt optional
- Adding token using macro
- Using prompt and promptmany macros in query subject
- Showing the prompt values in report based on security
- String operations to get it right
- Showing user name in footer
- 9. Using Report Studio Better
- Introduction
- Report Studio environmental options
- Copy-pasting partial or full report
- Copy-pasting whole reports—8.2 to 8.4 possible
- Setting execution time out
- Setting maximum rows limit
- Handle slow report validation
- Capturing query
- Browsing values from data expression window
- Page structure view
- Pick-up and apply style
- Grab them all practice
- 10. Some More Useful Recipes
- 11. Best Practices
- A. Recommendations and References
- Index
In this chapter, we will cover the following:
- List reports or crosstab reports
- Filtering rows or columns
- Filtering a whole report
- Achieving zero suppression
- Adding a prompt into Slicer and its limitations
- Level independent MUN for parent-child hierarchy
- Aggregation versus pre-aggregated values
- Using the RoleValue function
- Swapping prompt values while filtering
This chapter will discuss some concepts that you should know when developing reports against dimensional or DMR (Dimensionally Modeled Relational) sources. We will use two packages in this chapter. The "GO Data Warehouse (analysis)" package is of DMR type, whereas 'GO Sales SSAS Cube' is a SQL Server Analysis cube-based package which is purely dimensional in nature.
The GO Data Warehouse (analysis) package comes as a standard sample with Cognos installation and can also be downloaded from the Packt website.
I have created the "GO Sales SSAS Cube package" to connect to the Microsoft SQL Server Analysis Services (SSAS) cube that comes with the Cognos sample installation. You can also use other sample cubes (Essbase or Powercube). You can download this package from the Packt website or even easily create one.
-
No Comment