Restrict a column Using Variables in SAP HANA

Scenario:

Create a calculation dimension View for Customer and restricted only US country in Data Preview.

Solution:

Steps:

1. Create a Calculation dimension view for the customer. Here I named it as “CV_DIM_CUSTOMER”.
2. Here, I used 3 tables named as the KNA1 and T005T and T005U Tables.
3. Drag and drop the above tables into separate projection Node.
4. And join it .
5. Join 1 as shown below:
   
   
   
   
   
   
   
   
   
6. Join 2 as shown below:
   
7. Finally, it looks like:
   
8. To restrict a column we have to create a "Variable".
   
9. Create a Variable in the semantics.
• Here I need to restrict US country only. So, I Put the value “US” .
• Reference Column: LAND1 i.e., Country_KEY
10. Then Click validate and activate the view
11. Results:
    

Thanks For Visiting my blog. 

Share your Comments...