SAP HANA Modeling

Blog Author


Published Date

22nd September, 2020




  • Share this blog :


SAP HANA Data Modeling

SAP HANA Pre-requisites

Add HANA DB to HANA Studio

HANA DB Creation

HANA Schema (System / Custom schema)

Data Provisioning (ETL / Log / Trigger ) CDC / Transaction loading configuration using replication agent server / (Resume/suspended loading)

Normal loading/mass import

Copy DATA from SAP schema to custom schema

Loading data via information composer

View the data from content (SYS-REP)


Create Package

Create information objects (Attribute view / analytical view / calc., view)

Manage views (w.r.t attribute / Analytical / calc. view)




Auto documentation

Import model

Export model


Multi-language support

Configuring modular preferences

Preparing to deliver a unit

Business Modeling

Use LDT (Create RDLAP conn (1…..N) / Data foundation / Business layer Use Business layer (.UNX) in UntitledExplorer UntitledInformation Analysis development UntitledWebi 4.0 UntitledDashboard UntitledCrystal enterprise UntitledAdvance Analysis Use Webi / explorer on / PAD using blackberry exchange Server We can take multiple views in a Single business layer will get a huge amount of data within micro/millisecond

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

Workflow for HANA Modeling

1) Package UntitledStructural pkg. linear pkg


2) Attribute view Analytical view Calu. View


3) Analytical Privilege Untitled User-specific roles with respect to access of attribute


4) Preview data Untitled Accuracy Performance


5) Validate  Untitled   SQL joins


6) Compose Versions of modals Untitled Version control check-in / Check out


7) Ownership Assignment Untitled Authorization of uses to models


8) Multilanguage Script Untitled Translation


9) Object doc. (End to End doc)


10)Model references Untitled Depends on Another mode/model


11)Import / Export models from Service/Client


12)Delivery units




  14)Der   Untitled  Testing   Untitled    Production




16) BI  

SAP HANA Tutorials

Row-based view

Here we can create views directly from “Tables”. Row-based views are Relational views.

Procedure to create views

Create a view (Row-based) on a single table

Right-click on any table Select ‘New View” Untitled  Right side type (provide) ‘view name’ Untitled Schema Name So Select required felids and Drag into the column pane

Note: We must take at least one column to select Required columns  Validate and activate the view and we can view the data

Note: These relational views stores under view folder understanding schema

SAP HANA Modeling

SAP HANA Modeling  

FULL – OUTER JOIN: It brings common values as well as extra values from two ‘Tables’

By creating “VIEW” we follow steps

1) Join Tables with join type – Kinner / outer (Left, Right, / full)

2) We need to select specified fields and Drag them into the column pane.

3) Validate and Activate

Difference between column views & row-based views

Row-based Views

It is ‘Relational Based view’ Here we can use Inner / Outer Joins Here we can take only columns from Tables. We cannot create Extra calculated columns (Custom) This type of views are specific to schema This views stores under the views folder in schema We cannot provide these views for BO we can save there as excel format

Column based View

It is an ‘OLAP based view” (only Analytical views)

Here we can create custom columns.

These views created under packages

full column-based views stores under “—sys –bic” schema for End-user Excel. BO.

For in-depth knowledge on SAP HANA, click on below

About Author


Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .

Related Blogs

Write For Us