SAP HANA 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)
Process
Create Package
Create information objects (Attribute view / analytical view / calc., view)
Manage views (w.r.t attribute / Analytical / calc. view)
Preview
Validation
Versioning
Auto documentation
Import model
Export model
Ownership
Multi language support
Configuring modular preferences
Preparing delivering unit
Business Modeling
Use LDT (Create RDLAP conn (1…..N) / Data foundation / Business layer
Use Business layer (.UNX) in 
Explorer
Information Analysis development
Webi 4.0
Dash board
Crystal enterprise
Advance Analysis
Use Webi / explorer on / PAD using blackberry exchange Server
We can take multiple views in a Single business layer will get huge amount of data within micro / milli second
Interested in mastering SAP HANA Certification? Enroll now for FREE demo on SAP HANA Training.
Work flow for HANA Modeling
1) Package Structural pkg. linear pkg
↓
2) Attribute view
Analytical view
Calu. View
↓
3) Analytical Privilege User specific roles with respect to access of attribute
↓
4) Preview data Accuracy Performance
↓
5) Validate SQL joins
↓
6) Compose Versions of modals Version control check in / Check out
↓
7) Ownership Assignment Authorization of uses to models
↓
8) Multi language Script Translation
↓
9) Object doc. (End to End doc)
↓
10)Model references Depends of Another mode / model
↓
11)Import / Export models from Service/Client
↓
12)Delivery units
↓
13)Logs
↓
14)Der Testing Production
↓
15)BOLANDSCAPS
↓
16) BI
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 single table
Right click on any table
Select ‘New View” Right side type (provide) ‘view name’ Schema Name
So Select required felids and Drag into the column pane
Note
We must take at least one column select Required columns Validate and activate view and we can view the data
Note
These relational views stores under view folder understanding sachema
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 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 views folder in schema
We cannot provide these views for BO we can save there as excel format
Column based View
It is ‘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 an Indepth knowledge on SAP HANA, click on below