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: Time
, Customer
, Product
, Channels
, Employees
, and so on. Setting up these levels of the dimensions is dependent on business requirements. Business users should decide about the granularity levels.
The
Time
dimension might have five levels starting from the GRAND TOTAL level to the DAY level, and we are going to use five-level dimension in our scenario. This can be changed based on the business requirements. After creating this dimension, users will drill down from YEAR to QUARTER, then to MONTH, and then to the...