SAP HANA: Restricted Column

Create Restricted Columns

Create restricted columns to restrict values of measures based on attribute restrictions. For example, you can choose to restrict the value for the REVENUE column only for " REGION = Australia ".

Just as the name suggests, a restricted column is a user-created column that is restricted in its output by a condition that we specify.

Context

You can apply restrictions on measures defined in the semantics node by using any of the below approaches:

1.      Apply restrictions on attribute values by using values from other attribute columns.

2.      Apply restrictions on attribute values using expressions.

Note

For restricted columns, modeler applies the aggregation type of the base column, and you can create restricted columns in the default aggregation view node or star join node only.

Example:

            Here I restrict a Sales value based on region.

Procedure

1.      Open the required Analytic view or graphical calculation view in the editor. Here I used Analytic view “AN_ADW_FACT_INTERNET_SALES”.

2.      Select the default aggregation node.

Note:

You can also create restricted columns in star join nodes.

3.      Choose the Restricted Columns tab.

4.      Choose

5.      In the General section, provide a name and description to the restricted column.

6.      In the Column dropdown list, select a measure on which you want to apply restrictions.

7.      If you want to hide the restricted column for data preview, select the Hidden checkbox.

8.      Apply restrictions using column values.

a)      You can define a condition using attribute columns to apply restrictions on the base measure.

b)      Select Columns.

c)      In the Column dropdown list, select an attribute column.

d)      In the Operator dropdown list, select a required operation to define the condition.

e)      In the Value field, select a value from the value help.

f)       If you want to apply restrictions only for the defined conditions, choose Include.

Note:

You can apply restrictions using more than one attribute column.

9.      It will be like as shown as below:

10.  Click “OK”.

11.  The output pane will be like this:

12.  And Validate and Activate the view.

13.  Result: Data Preview

Thank you...

Share your Comments...