Found 1044 Articles for SAP

Creating a mandatory variable in SAP HANA View

SAP Expert
Updated on 18-Jun-2020 09:33:21

150 Views

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

Defining Parameters/Variables in an Analytic View in SAP HANA

Anil SAP Gupta
Updated on 18-Jun-2020 09:32:25

132 Views

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.

Consuming Attribute views in an Analytic view in SAP HANA

SAP ABAP Expert
Updated on 18-Jun-2020 09:28:51

127 Views

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.

Using Analytic View in SAP HANA

SAP Developer
Updated on 18-Jun-2020 09:21:55

210 Views

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

Different options in Data Preview in SAP HANA

John SAP
Updated on 18-Jun-2020 09:25:59

460 Views

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.

Data Preview option in HANA Modeling view in SAP HANA

SAP ABAP Expert
Updated on 18-Jun-2020 09:05:24

425 Views

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:

Activating an Attribute view in SAP HANA

Anil SAP Gupta
Updated on 12-Mar-2020 11:39:45

113 Views

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.

Performance Analysis of an Attribute view in SAP HANA

SAP Developer
Updated on 18-Jun-2020 08:59:49

281 Views

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.

Checking column properties in an Attribute view in SAP HANA

John SAP
Updated on 18-Jun-2020 09:02:41

146 Views

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

Adding columns to output in an Attribute view in SAP HANA

Anil SAP Gupta
Updated on 12-Mar-2020 11:37:57

541 Views

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.

Advertisements