Different Types Of Views In SAP HANA
SAP HANA Attribute Views
We can create this view on master tables
Here we can take one or more tables
Be the case of multiple tables we need to join them with cardinalities
Will get selected tables in the data foundation tab
We need to use output pave to create the structure of the view
In output pave we have two folders
1) Attributes (fields form TABLES in BATN FOUNDATION)
2) Calculated attributes (to customized objects to perform calculator on attributes which are available in output pave by using functions, operation provided by SAP)
Note:- be attribute folder we must take at least one key attribute. Attribute view we can create two types of hierarchies
1) Level based hierarchy - Based on Level.
2) Parent-child hierarchy - slier we can create a hierarchy for the key field in the attribute folder
In a parent-child hierarchy, we must provide parent for the key attribute of the attribute view
Note:- We can create either calculated attribute / Hierarchy based on attributes under the attribute folder in output pave.
Note:- here we want to use massive
Validate & Activate
Our attribute view will appear in our package as well as – sys – Bic schema.
SAP HANA Analytic Views
It is used to define multi discussional view (OLAP cube) Based on database tables, attribute views and faints of a specific table
Create Package
Create Analytic View
Select Tables (1 or more)
Inclined to build a profession as SAP HANA Developer? Then here is the blog post on, explore SAP HANA Training
Note:- We must take at least one fact table
Select any member of attributes vies
Will get tables under data foundation pane
Join them with cardinalities
In output pave will create the structure of the analytic view
Under attribute, view folder will get selected attribute views
In the private view, the folder will take fields from tables under the data foundation pave.
We can create custom objects under the calculated attribute folder to perform calculations on dimension touch are available in private attribute folder and attribute folder
Take measures from a table available in the DATA foundation
Create custom objects to perform calculations on measures which are available measures under the measure folder
We can create a restricted key figure to restrict key figure volumes based on dimension volumes
Here we can include or exclude values
Create variables to pass values at runtime
After creating objects
Go to logic view pave and map data foundation table and attribute views table.
Validate & Activate
Will get a view under –sys—BIC
SAP HANA Calculation Views
We can create a calculation view in two ways
1) Graphical
2) Script
SAP Hana Calculation view is to perform calculations on tables, attribute view, analytical view and calculated view.
In Graphical view, we can join two more tables or views as well as we can perform union and projections
In the Graphical view, we can perform union and projections
In SQL based calculated view, we can write SQL statements to perform calculations on views, tables,
It places a major role in SAP HANA to perform calculations on tables and views
Note:- In Information composer, we can create only on tables, analytical, attribute and calculated views
Calculated View with Graphical
Right click as a package
Create view calculated view
Select Graphical type
Select tables
Note:- We used to select at least one fact table
Select views (Attribute, analytical and calculated views)
We will get three screens
The first screen will get selected tables/views
In second screen will get components of tables/views in first screen
In third screen output structure
Scenario
Create calculated view on single table / view
Step 1 :- Create new calculated view
Step 2:- Select table / view
Step 3:- In first screen will get table/view and component of output structure.
Step 4:- Select projection component in first screen
Note:- Projection is component to increase the performance of retrieving the data from database and we can calculate for new values.
In first screen connect table / view to projection and connect projection to output structure component.
Select projection component in first screen will get table in second screen
Select fields for output column and right click set as output column
Select output structure in fist screen so will get table in second screen which contains selected output columns in projection
Again select fields for dimensions, select fields for measures,
Create calculated attribute objects to perform calculations on attributes which are available in attributes in output
Create calculated measure to perform calculations on measures which are available in output screen
Create variable to parameters to respect key figure value based on attribute values
Validate
Activate it
View Scenarios
Note:- We must take attest are fait table & we must take at least one measure
Projection always recommended to take for tables and views to increase the performance
Here we can exculpate view columns and variables
Whatever we take Column for output pane will get in output structure and we need to classify those objects as attributes, measures in output structure
For an Indepth knowledge on SAP HANA, click on below
- Security in SAP HANA
- Organizing system Landscapes in SAP Hana
- Analytical Privileges in SAP HANA
- Security in SAP HANA
- SAP ERP RDS for profitability analysis with SAP HANA – data provisioning