Creating level-based measures
A level-based measure is a column whose values are calculated to a specific level aggregation such as
StateRevenue. For example, if the business users want to calculate the total revenue for the GRAND TOTAL level of the
Customer dimension, we're going to create a level-based measure, which will be mapped to GRAND TOTAL level of the
Customer dimension and this will calculate total revenue across all regions.
In order to create the level-based measure, dimensions and hierarchies should be created before. Then we're going to create a new logical measure column and map it to a specific level.
How to do it...
- First step will be creation of a logical measure column. So we're going to right-click on the fact ...