Create Simple View From Different Sources in SAP HANA
Creation of simple view from different sources
From R3 table : (ETL Based replication)
Create Data Store for SAP HANA (Target)
Create Data store for SAP R3 (source)
Import any table into SAP R3 data store (Required table)
Create project
Create batch job
Create workflow
Create dataflow {(Create ABAP data flow (Provide source data store
(SAPR3), ABAP program name, ABAP program file name,
Job name and ABAP dataflow name)}
In ABAP dataflow take our imported table prom our data store (R3 DST) take query transformation, take transport connection, in query transformation map all fields (if there is no primary key), data transport connection provide name for transport connection file
In data files take Query transformation, connect Query transformation to ABAP dataflow map all fields whatever you want, map Query transformation and to get table
(take from HANA Data store)
Right click on job and execute it.
SAP HANA Studio
After Successful execution go to HANA modeler (Studio)
Go to modeler quick launch
Click on SQL editor
Enter the Query
[Create Schema <schema name>]
Expand system catalogue (We have created target HANA table under system catalogue in Data Services)
Select our table, right click and select new view
In Right side will get table
Drag columns to column pane
Provide View name and our newly created catalogue and execute
Refresh our nerdy created catalogue and expand it
Under cataloger expand view and we will get newly created view.
Interested in mastering SAP HANA Training? Enroll now for FREE demo on SAP HANA Training.
Note:- If you want to export our view to client system in the form of CSR we can edit by selecting view preview
We can display in 2 ways
1) Tables
2) C ports
Right click an view
Select Open data preview
Will get data in 3 ways
1) Raw Data Will get data in the form of tables
2) Distinct Values It retrieves distinct value in a column
3) Analysis It displays data in the form of table or chrts based on selected Objects, filters in a Query.
BD
Create IDT (Information design tool)
Create Project
Creation Relational connection
Select SAP
↓
SAP High performance Analytic Appliance
↓
ODBC
- Provide username, password, ODBC connection for HANA
- Test connect NEXT
Finish.
- After creating relation connection will get in the form of CNX
- We need to public connection to a repository.
- Provide password and publish will get connection in the form of cns
- Create Data foundation
- Take view from our catalogue and save it.
- Create business layer
- Select our data foundation
- Publish our business layer to system repository
- Create any report
Learn more about SAP HANA Interview Questions in this blog post.
From R3 Extractors
Create data store for SAP HANA (Target)
Create data store for SAP R3 (Source)
Import any extractor into SAP R3 data sore (required extractor)
Create Project create batch job
create work flow
Create data flow {(Create ABAP dataflow (Provide source data store (SAP R3), ABAP program name, ABAP program file name, job
Name and ABAP dataflow name)}
In ABAP dataflow take our imported extractor from Our DST (R3 Data store), take Query transformation, take transport connection in query transformation map all fields (if there is no primary key), data transport connection provide name for transport connection file
In dataflow take Query transformation, connect Query transformation to ABAP dataflow map all fields whatever you want, map query transformation and target table (take from HANA Data store)
Right click on job and execute it
From flat file
Create file format for source file in DS (Source)
Create HANA data store for Target
Create Project
Create batch job
Create work flow
Create dataflow
Take file as source
Take Query transformation
Take Target table of HANA
Executive Project
SAP HANA Studio
Same as table
From SQL DB
Create Data store for SQL DB (Source), Import required table
Create data store for HANA DB (Target)
Create Project Create batch job Create workflow create dataflow Take SQL Table as source Take Query transformation
Take target table for HANA Data store
Execute Project
HANA STUDIO
Same as table
SAP BI TABLE
Create DST for B1/BW Data store (Source) Import required table
Create DST for HANA (Target)
Create Project Create Batch job Create workflow Create data flow {(Create ABAP dataflow (provide source DST (SAP B1/BW), ABAP program name,
ABAP program file name, job name and ABAP dataflow name)}
In ABAP data flow take Our Imported take from our Data Store, take Query transformation, take transport connection, in query transformation map all fields (if there is no primary key), data transport connection provide name for transport connection file.
In dataflow take Query transformation, connect Query transformation to ABAP dataflow map Query transformation and target table (take from HANA DST)
HANA Studio
Same as table
BO
Same as table
Information Compares
It is a web based environment which allows business users to upload data into SAP HANA data base and create information views
URL: http://sysname.domain.com:8090/ic/
It is used to create calculated views
It creates information views by using
Excel files
Attribute view
Analytic view and
Calculated view
Which is coming from HANA DB
In Information composer we need upload data from client system in the form of .xls, .xlsx, and .csv
Compose the data:
In compose we can combine two different databases by using joins and unions
For an Indepth knowledge on SAP HANA, click on below