Chapter 5. Modeling Dimensional Data
This chapter will cover the use of dimensional modeling, which is more correctly called Dimensionally Modeled Relational (DMR) data. The dimensional models created can be used with IBM Cognos Analysis Studio, and also with the other studios.
In this chapter we will cover the following:
- Creating regular dimensions
- Creating regular dimensions with multiple hierarchies
- Creating measure dimensions
- Creating scope dimensions
By the end of this chapter, you will be able to create a dimensional data model using relational data sources.
Dimensional modeling is the name for a set of techniques and concepts used in data warehouse design. Dimensional modeling is based on the concepts of dimensions (or context) and facts (or measures). ...
Get IBM Cognos 10 Framework Manager 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.
