SAP-HANA
SAP HANA Tutorial: Create Sequence
What is Sequence? A sequence is a database object that automatically generates the incremented list of...
SAP HANA Modelling is an activity by which we create information view. Information View is similar to dimension, cube or information provider of BW. This information view is used for creating the multi-dimensional data model.
In this tutorial, you will learn-
Modelling is an activity in which user refine or slice data in the database table by creating information view based on the business scenario. This information views can be used for reporting and decision-making purpose.
Information view is made from various combinations of content data to create a model for a business scenario.
Content Data in information view are of two types –
SAP HANA Support three Type of attributes -
Types of Attributes | Activities |
| It is derived from data foundation. |
| It is derived from one or more existing attributes and constants. E.g. Arithmetic calculation or derive the full name from the first and last name. |
| It is used inside modelling views (analytic View / calculation view) for Customize the behavior of attribute, so it is local to Modelling view and cannot access from outside of Modelling view. |
SAP HANA Support four Type of Measure –
Types of Attributes | Activities |
| It is derived from data foundation. |
| It is derived from one or more exiting measure, constants and function. E.g. Arithmetic calculation. |
| It is used to filter value based on user-defined rules for attribute values. |
| It is Special types of the column that display unique number for attributes Columns (Analytic View/ Calculation View). It is used in count the one or more attributes columns. |
Information Views are of three types as below –
In order to work in SAP HANA, privileges are required by user, below are privileges required for SAP HANA Modelling -
Privileges provide security to SAP HANA database, by which authorized user can access authorized content only.
Object Privileges –
Object privileges are SQL privileges which are used for providing read/write access on database objects. Below are object privileges are required for Modelling.
Package Privileges –
Package Privileges are required to authorize action on individual packages. Below are package privileges are required for data modelling-
Analytic Privileges –
To Access SAP HANA Information View Analytic Privileges are required -
Other Privileges-
SAP HANA Best Practice is standard while creating an object in SAP HANA Database. Below are best practice for object –
PACKAGE:
SCHEMA:
TABLES:
NAMING CONVENTION:
OBJECTS | Format | Description |
ATTRIBUTE VIEWS | AT_PRODUCT | AT_..... means Attribute View |
ANALYTIC VIEWS | AN_SALES | AN_.....means Analytic view |
CALCULATION VIEWS | CA_SALES | CA_..... means Calculation view |
ANALYTIC PRIVILEGES | AP_REST_AT(Attribute View) AP_REST_AN(Analytic View) AP_REST_CA(Calculation View) | AP_.... means Analytic Privileges |
HIERARCHY | HI_BNAME_PC(Parent Child) HI_BNAME_LV(Level) | HI_... means Hierarchy |
PROCEDURE | SP_PROCEDURENAME | SP_... Stored Procedure |
INPUT PARAMETERS | IP_PARA_NAME | IP_... means parameter |
VARIABLES | VA_VNAME | VA_...means variable name |
Package: It is a container that contains all information about the model (attribute view, analytic view, calculation view, etc. . .) in a group.
Types of package: Package are of two types, which is as below –
Description | ||
Structural | In Structural package, only sub-package can be created. No Information view (Attribute view, analytic view, etc.) can be created in Structural package. E.g. of Structural package – SAP, system-local, system-local. Generated, system-local. Private. | |
Non Structural | The Non-Structural package can contain information object and sub-packages. This is default package. |
Uses of Package: Package group are all information model, and make model transporting easier. Both packages can be used in transporting.
Steps for creating Structural Package in SAP HAN Studio-
STEP 1) In this step,
STEP 2) In this step,
STEP 3) In this step,
Non-Structural Package with Name "DHK_SCHEMA" will be created in Content node as below-
STEP 4) Now, convert Non-Structural Package to Structural Package.
STEP 5) In this step,
Our "DHK_SCHEMA" when changed from Non-Structural to Structural package the icon style will be changed from to
. This is an indication that non-structural package is now converted to the structural package.
Step for Creating Non-Structural package under Structural Package as sub-package.
The package is created by default as Non-Structural. In Non-Structural Package, other Package and information object can be created. It is better to first create a structural package, and then create a sub-structural package in it.
STEP 1) In this step,
STEP 2) In this step,
A new Non-structural package will be created as sub package under DHK_SCHEMA package.
There are the following rule for performance Optimization Technique –
What is Sequence? A sequence is a database object that automatically generates the incremented list of...
Import and Export option of SAP HANA Provide features to move tables, Information View, landscape...
Download PDF 1) Mention what is SAP HANA? SAP HANA stands for High Performance Analytical...
What are Attributes? Attribute view acts like a dimension. It join multiple tables and act as...
What is Sap HANA? SAP HANA is the latest, in-memory database, and platform which can be deployed...
In this tutorial, we will learn, 1) SAP HANA Data Type 2) SAP HANA Identifiers SAP HANA Data Type...