Level Based Measures

1. Can we do nested aggregate functions in RPD ? (example :SUM(SUM(ACTLEXTND)))
   
   No
   
   
2. What is level Based measure ?
   
   If a measure column is calculated on one particular level then it is called as level based measure.
    
3. What is the use of LBM ?
   
   Level based measures are useful to calculate share or percentages
   
4.  **Calculate Region wise Market share ?
   
   
   Step 1: Creating Level Based Measure
   
   
   1.    Duplicate Dollars column and rename it has grand total
   2.    Drag and drop grand total onto Customer Hierarchy à customer total level
   3.    Drag and drop grand total into presentation fact table .
   
   
   Step 2: Understanding or testing Level Based Measure
   
   
   1.    Go to reporting end and develop a report with region ,dollars , grand total.
   2.    Click on results. Notice that grand total displaying same value for all the rows that mean it is calculating at the level of total customers.
   
   
   Step 3: Using Level Based Measure in Share Calculations
   
   
   1.    Right click on sales fact table à New object à logical column à name it as share à click on column source tab à select derived from existing column using an expression à  Edit expression à double click on dollars column à double click on (/) divided  by à double click on Grand Total * 100 à click on ok à again ok.
   2.    Drag and drop share into sales presentation table à check in changes.
   
   
   Step 4: Testing
   
   
   1.    Reload server metadata. In above report (developed in step2 ) add one more column share à observe the result.
   
5. Calculate year wise share
   (Hint:Map Above GrandTotal column with time hierarchy GrandTotal Level)
   
6. Calculate Itemtype share
   
   (Hint:Map Above GrandTotal column with Product hierarchy GrandTotal Level)
7.  Calculate district share within region
   
   Duplicate dollars column and rename as region level total
   Map region level total to region level of customer hierarchy
   Create a new column with the name of district market share within region and develop below formula
8. 
   
9. Can we map a measure column with multiple levels of a hierarchy ?
   
   NO
   
10. **Develop a report with region, dollars(measure), grand total(LBM).if we click on central region then what will happens to dollars and grand total
    
    Dollars measure will split district wise where as grand total LBM wont split .