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 .