Chapter 7. Working with Dimensional Models
In this chapter we will cover the following:
- 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
- Using the roleValue() function
- Swapping dimensions using MUN manipulation
Introduction
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 Sales and Marketing (cube) is a Cognos PowerCube-based package which is purely dimensional in nature. Both packages come as a ...
Get IBM Cognos 10 Report Studio Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
