Level-based totally measures are created to carry out calculation at a selected stage of aggregation. They permit to return records at more than one degrees of aggregation with one single query. It additionally permits to create share measures.
Let us say there is a organization XYZ Electronics which sells its merchandise in lots of regions, nations and towns. Now the organization President desires to see the whole sales at u . S . A . Level - one stage below place and one degree above cities. So total revenue measure ought to be summed up to the us of a stage.
These type of measures are referred to as degree-based measures. Similarly, you could practice level-based measures at the time hierarchies.
Once the size hierarchies are created, level-primarily based measures can be created by means of double clicking on the whole sales column within the logical desk and setting the extent inside the levels tab.
Create Level-Based Measures
Open the repository in offline mode. Go to File → Open → Offline.
Select .Rpd file and click open → Enter repository password and click on Ok.
In BMM layer, proper-click on Total Revenue column → New Object → Logical column.
It will open the logical column dialog box. Enter the name of logical column total sales. Go to column source tab → Check derived from present columns the use of an expression.
Once you choose this option, expression edit wizard can be highlighted. In expression builder wizard, choose the logical desk → Column name → Total revenue from the left facet menu → Click OK.
Now go to degree tab in logical column dialog field → Click on logical size to choose it as grand total beneath logical degree. This specifies that the measure ought to be calculated at grand general stage inside the measurement hierarchy.
Once you click on OK → Total Revenue logical desk will seem under the logical size and Fact tables.
This column can be dragged to presentation layer inside the subject place to be used by end users to generate reports. You can drag this column from reality tables or from logical measurement.