Defining Parameters/Variables in an Analytic View in SAP HANA

Variables are used as an explicit SQL filter directive for view consumers to filter the view data, based on attribute column values specified in variable UI prompt of a BI Client.

To define a variable, you need to navigate to Semantics in a view → Go to Parameters/Variables and click on drop down next to the + sign.

Anil SAP Gupta

Published on 23-Apr-2018 08:37:28

• Related Questions & Answers
• Using Analytic View in SAP HANA
• Consuming Attribute views in an Analytic view in SAP HANA
• Consuming Attribute/Analytic view in a Calculation view in SAP HANA
• Defining a primary key in an Attribute view in SAP HANA
• Query in Analytic view creating unexpected results in SAP HANA
• Creating Attribute and Analytic view as persistent model in SAP HANA
• Creating Attribute and Analytic view as persistent model in SAP HANA
• Using an Analytic Privilege for specific time in SAP HANA
• Activating an Attribute view in SAP HANA
• Creating an Attribute view in SAP HANA
• Using Operators in Analytic Privilege in SAP HANA
• De-normalization and Analytic views in SAP HANA
• Adding multiple views in SAP HANA Analytic Privilege
• Defining user lock settings in SAP HANA
• Performance Analysis of an Attribute view in SAP HANA