A level-based measure is a column whose values are calculated to a specific level aggregation such as YearRevenue
or 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.
First step will be creation of a logical measure column. So we're going to right-click on the fact table and select the new Logical Column option.
When the Logical Column window comes up, we're going to write the name of the measure column.
Region Total Dollars
is used in the example.Instead of mapping this logical column with a physical column, we...