Chapter 7. Working with Dimensional Models
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
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 'GO Sales SSAS Cube' is a SQL Server Analysis cube-based package which is purely ...
Get IBM Cognos 8 Report Studio Cookbook 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.
