Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP HANA Articles
Page 6 of 58
Advantages of using Calculation View without Star Join
When you use Calculation view with Star Join, you have the following benefits:It simplifies the design process.You need not create Analytical views and Attribute Views and directly Fact tables can be used as Projections.3NF is possible with Star Join.
Read MoreApplying Variable on calculated column in SAP HANA Modeling view
Yes, you can set a variable on top of “Calculated column”. In the bottom box, you need to select the column on which you want to set a Variable.Click on Add and from the drop-down, you can select “Calculated column” as below:
Read MoreHiding a column in Data Preview in SAP HANA
In Analytic View, to hide few of columns you have to click on Semantics in scenario pane. There you can select the checkbox in front of column name that you want to hide.
Read MoreCreating a mandatory variable in SAP HANA View
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
Read MoreData Preview option in HANA Modeling view in SAP HANA
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:
Read MoreChecking column properties in an Attribute view in SAP HANA
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
Read MorePerformance Analysis of an Attribute view in SAP HANA
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.
Read MoreUse of Data Foundation in Attribute view in SAP HANA
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.
Read MoreDifference between Copy and Derived view in SAP HANA
Following are the key points about using Derived view in SAP HANAThe derived attribute view will be similar in all the characteristics as the base view (except the name) It is not possible to edit any semantic/data foundation design in the derived attribute view. When there is any change in the base view, the changes will be reflected in the derived attribute view too. This helps reduce extra efforts of replicating the changes in the derived view.When you want to define an Attribute view on the top of an existing object as copy, you can use Copy From option. This can be ...
Read MoreUsing Time subtype of an attribute view in SAP HANA
Time subtype Attribute View is a special type of Attribute view that adds a Time Dimension to Data Foundation. To know more about the difference between Standard Attribute view and Time Attribute view, you can refer this SAP thread:https://archive.sap.com/discussions/thread/3253551
Read More