How to create Variables,Calculated Attributes, Calculated Measures, Restricted Measures, Filters In SAP HANA.

[Former Member]

Note:- Click on the images to see clearer and larger images.

Define Calculated Attributes.

1. In the Output pane, right-click Calculated Attributes.

2. From the context menu, choose New.

3. Enter a name and description for the calculated attribute.

4. Choose the Key tab page.

5. Select the data type for the calculated attribute.

6. Enter the length and scale.

7. Define the attribute using the required attributes, operator, and function.

8. Drag and drop the required function onto the Expression Editor.

9. Click Add.

 

In the below picture I used Weekday function from Date Functions. If you want to more about functions click on the link provided at the end of this blog.

Defining Calculated Measures.

1. In the Output pane, right-click Calculated Measures.

2. From the context menu, choose New.

3. Enter a name and description for the calculated measure.

4. Select the required Aggregation Type.

5. If you want to hide the measure while previewing data, select Hidden.

6. Select the required data type for the calculated measure.

7. Enter the length and scale.

8. Define the measure by selecting the required measures, operator, and function.

Defining Restricted Measures.

1. In the Output pane, select Restricted Measures.

2. From the context menu, choose New.

3. Enter a name and description for the restricted measure.

4 Choose the measure from the drop-down list.

5 To add a restriction, choose Add Restriction.

6 Select the required parameter, operator, and value.

7 Choose OK.

 

Creating Variables

You use this procedure to assign variables to a filter at design time for obtaining data based on the

values you provide for the variable. At runtime, you can provide different values to the variable to view

the corresponding set of attribute data. You provide values to the variables either by entering the values

manually, or by selecting them from the Value Help dialog.

Note: You can apply variables to attributes of analytic and calculation views.

Create a Variable

1. In the Output pane, right-click the Variables node.

2. From the context menu, choose New and perform the following substeps:

     a. Enter a name and description.

     b. Select the required attribute from the drop-down list.

Note: At runtime, the value for the variable is fetched from the selected attribute's data.

     c. Choose the required Selection Type from the drop-down list.

     d. Choose OK.

The following types of variables are supported:

Single Value: - Use this to filter and view data based on a single attribute value. For example, to

view the sales of a product where the month is equal to January.

Interval: - Use this to filter and view a specific set of data. For example, to view the expenditure

of a company from March to April.

Range:-  Use this to filter and view data based on the conditions that involve operators such as "="(equal to), ">" (greater than), "<" (less than), ">=" (greater than or equal to), and "<=" (less than or equal to). For example, to view the sales of all products in a month where the quantity sold is >= 100.

Each type of variable can be either mandatory or non-mandatory. For a mandatory variable, you need

to provide a value at runtime. However, for a non-mandatory variable, if you have not specified a value

at runtime, you view unfiltered data.

Note:  You can check whether a variable is mandatory or not from the properties of the variable in the properties pane.

Assign a Variable to a Filter.

1. On the Logical View tab page, right-click the attribute.
2. From the context menu, choose Apply Filter.
3. From the Operator drop-down list, choose Variable.
4. From the Variable drop-down list, choose the required variable.
5. Choose OK.

Note: You can also choose to create a variable and apply a filter using the Create Variable - Apply Filter

option from the context menu of an attribute.