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 to deliver a unit
Inclined to build a profession as SAP HANA Developer? Then here is the blog post on, explore SAP HANA Training |
Use LDT (Create RDLAP conn (1…..N) / Data foundation / Business layer Use Business layer (.UNX) in Explorer Information Analysis development Webi 4.0 Dashboard 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 a huge amount of data within micro/millisecond
Workflow 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) Multilanguage Script Translation
↓
9) Object doc. (End to End doc)
↓
10)Model references Depends on Another mode/model
↓
11)Import / Export models from Service/Client
↓
12)Delivery units
↓
13)Logs
↓
14)Der Testing Production
↓
15)BOLANDSCAPS
↓
16) BI
Here we can create views directly from “Tables”. Row-based views are Relational views.
Checkout our Blog on SAP HANA Tutorial |
Create a view (Row-based) on a 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 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
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
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
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
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
1/15
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 in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox