SAP HANA Views

Different Types Of Views In SAP HANA

SAP HANA Attribute Views

We can create this view on the 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 customize objects to perform calculator on attributes which are available in output pave by using functions, and operations provided by SAP)

Note: In 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 the parent with 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.

Inclined to build a profession as SAP HANA Developer? Then here is the blog post on, explore SAP HANA Training

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)

Note:- We must take at least one fact table

Select any member of attributes vies

Will get tables under the data foundation pane

Join them with cardinalities

In output pave will create the structure of the analytic view

Under attribute, the 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 the private attribute folder and attribute folder

Take measures from a table available in the DATA foundation

Create custom objects to perform calculations on measures that 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 to perform calculations on tables, attribute view, analytical view and calculated view.

In the 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 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

The second screen will get components of tables/views in the first screen

In the third screen output structure

Scenario

Create a calculated view on a single table/view

Step 1: Create a new calculated view

Step 2: Select table/view

Step 3: In the first screen will get the table/view and component of the output structure.

Step 4: Select the projection component on the first screen

Note: Projection is a component to increase the performance of retrieving the data from the database and we can calculate for new values.

In the first screen connect the table/view to the projection and connect the projection to the output structure component.

Select the projection component on the first screen will get a table on the second screen

Select fields for the output column and right-click set as an output column

Select the output structure on the first screen so will get the table on the second screen which contains selected output columns in the projection

Again select fields for dimensions, select fields for measures,

Create calculated attribute objects to perform calculations on attributes that are available in attributes in the output

Create calculated measures to perform calculations on measures that are available in the output screen

Create variables to parameters to respect key figure values based on attribute values

Validate

Activate it

Checkout our Blog SAP HANA Tutorial

View Scenarios

Note: We must take attest are fait table & we must take at least  one measure

Projection is 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 the output pane will get in the output structure and we need to classify those objects as attributes, and measures in the output structure

For In-depth knowledge of 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