• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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 UntitledExplorer

UntitledInformation Analysis development

UntitledWebi 4.0

UntitledDash board

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 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      Untitled       Structural 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) Multi language Script    Untitled  Translation

      ↓

9) Object doc. (End to End doc)

      ↓

10)Model references  Untitled   Depends of Another mode / model

      ↓

11)Import / Export models from Service/Client

       ↓

12)Delivery units

   ↓

13)Logs

   ↓

 

14)Der   Untitled  Testing   Untitled    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”     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 select Required columns  Validate and activate view and we can view the data

Note

These relational views stores under view folder understanding sachema

Screenshot_46

Screenshot_47

 

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

Summary
Review Date
Reviewed Item
SAP HANA Modeling
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on SAP HANA Modeling"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.