This section explains the steps to be performed by the user for adding a new dimension to the cube.
As a prerequisite, dimension tables should be added in the data model and the fact table needs to have the referential key with the dimension table. These dimension tables will hold dimension members and can be level-based or parent-child.
Level based dimension tables contain columns for each level of the hierarchy, while parent-child dimension tables contain columns for storing the relationship between the parent and child members. These dimension tables can be loaded from external systems or can be maintained within the Dimension Management component of OFSAAI.
If user intends to maintain the dimension within OFSAAI, see Data Model Utilities Guide for adding dimension tables under "Object Management" chapter.
This chapter discusses the following topics:
· Dimension Definition Process
· Metadata