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). Dimensions are groups of hierarchies and descriptors that define the facts; facts are typically numeric values that can be aggregated.
Dimension modeling is one of the functions available within Framework Manager. With the dimensional modeling...