SAP HANA Articles - Page 32 of 69

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.

This can be done by selecting column name from the list of columns under Output pane.

You can get a permanent license key from SAP Marketplace under Keys and Requests tab. To install a new key, you have to click on Install License key option and then you need to browse the path of license key saved on your system.You can also delete an existing license from there.When you click on Install, you will be prompted to pass the path of HANA license key. You need to browse and then you can setup a new key. When you click on Install, you will be prompted to pass the path of HANA license key. You need to browse ... Read More

When you enter the Attribute name, Type, and Subtype and click on Finish, it will open three work panesScenario pane that has Data Foundation and Semantic Layer.Details Pane shows attribute of all tables added to Data Foundation and joining them.Output pane where we can add attributes from Detail pane to filter in the report.You can add Objects to Data Foundation, by clicking on ‘+’ sign written next to Data Foundation. You can add multiple Dimension tables and Attribute Views in the Scenario Pane and join them using a Primary Key.

Note that there are 2 types of Permanente license key types in HANA. If you are using unenforced license key, your system will be locked out in this case.Unenforced: If the unenforced license key is installed and consumption of HANA system exceeds the license amount of memory, the operation of SAP HANA is not affected in this case.Enforced: If the Enforced license key is installed and consumption of HANA system exceeds the license amount of memory, HANA system gets locked. If this situation occurs, HANA system has to be restarted or a new license key should be requested and installed. ... Read More