SAP Articles - Page 32 of 104

Yes, this is possible. When you create variable in HANA, you have an option to make it as a mandate. Also from the drop down, you can make Selection type as Range or Interval

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.

When you create an Analytic View, you get an option of Data Foundation and Star Join. At Data Foundation level you can add objects- columnar tables and at Star join you can add other Attribute views.When you click on “+” sign, you get an option to search all Attribute views in the repository.

You are correct. In SAP HANA, Analytic Views are used to implement Star Schema queries wherein we join one Fact table to multiple Dimension tables. Analytic views use the real power of SAP HANA to performcomplex calculations and aggregate functions by joining tables in form of star schema and by executing Star schema queries.Following are key characteristics of SAP HANA Analytic View:Analytic Views are used to perform complex calculations and Aggregate functions like Sum, Count, Min, Max, Etc. Analytic Views are designed to run Start schema queries.Each Analytic View has one Fact table surrounded by multiple dimension tables. The fact table ... Read More

When you click on Data Preview, you can see these optionsAnalysisDistinct ValueRaw DataWhen you use an Analytic view, under Analysis tab you can see both Attributes and Measures under Available objects and it can be dragged to Label and Value axis.Similar way you can “Distinct value” tab to see the distinct values and “Raw data” to check all raw data available in HANA view.

Once HANA Modeling view is activated, you can use Data Preview option to analyze the data in HANA Modeling view. To see Data Preview, you can right-click on View name → Data PreviewYou can also click on the icon as shown in below snapshot:

This can be checked by looking at view name in a package. If there is a Grey diamond mark on the name it means View is not activated.

In SAP HANA Modeling, you have an option of switching to Performance Analysis mode. This is used to check if Joins in Attribute view are meeting with performance optimized joins and cardinality based on data in the table.You can see 2 options when you select Performance Analysis mode:Join Details:This defines Join type used and proposed cardinality based on data in the tableData Source Details:Defines table type, partition type and a number of rows in tables.

This can be easily checked in Details pane. You need to select column name for which you want to check Properties of a column → right click → Properties

This can be done in 2 waysYou can directly click on round circle in front of the column name in Details PaneYou can add a column to output by right click on the column and select → Add to OutputWhen you add a column to output pane, it is added in Output pane on the right side under columns list.