In this chapter, we will cover:
Logical Dimensions consists of hierarchies and they are created in the Business Model and the Mapping layer. They enable end users to drill down to details, and measures that will be based on levels can also be created. Besides these functions, we can also gain the benefit of using aggregate tables in order to improve query performance.
Logical Dimensions are representations of hierarchical organization of logical columns. There are some common examples of dimensions: