Creation of a simple view from different sources
From R3 table : (ETL Based replication)
Create a Data Store for SAP HANA (Target)
Create Datastore for SAP R3 (source)Import any table into SAP R3 data store (Required table)
Create a project
Create a batch job
Create workflow
Create dataflow {(Create ABAP data flow (Provide source datastore
(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 provides a 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 a table
(take from HANA Datastore)
Right-click on the job and execute it.
SAP HANA Studio
After Successful execution goes to the HANA modeler (Studio)
Go to modeler quick launch
Click on SQL editor
Enter the Query
[Create Schema <schema name>]
Expand system catalog (We have created a target HANA table under system catalog in Data Services)
Select our table, right-click and select a new view
In the Right side will get a table
Drag columns to column pane
Provide View name and our newly created catalog and execute
Refresh our nerdy created catalog and expand it
Under the cataloger expand the view and we will get a newly created view.
Note:
If you want to export our view to the 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 a view
If you want to enrich your career and become a professional in SAP Hana, then visit Tekslate - a global online training platform: "SAP Hana Adminstration Training" This course will help you to achieve excellence in this domain
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 tables or charts based on selected Objects, filters in a Query.
BD
Create an IDT (Information design tool)
Create a 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 a relationship connection will get in the form of CNX
- We need to public connection to a repository.
- Provide the password and publish will get a connection in the form of CNS
- Create Data foundation
- Take a view from our catalog and save it.
- Create a business layer
- Select our data foundation
- Publish our business layer to system repository
- Create any report
Checkout Our Frequently asked SAP Hana Interview Questions
From R3 Extractors
- Create a data store for SAP HANA (Target)
- Create a data store for SAP R3 (Source)
- Import any extractor into SAP R3 data sore (required extractor)
- Create Project
create a batch job
create a workflow
- 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 Datastore), take Query transformation, take transport connection in query transformation map all fields (if there is no primary key), data transport connection provide a 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 Datastore) Right-click on the job and execute it
From flat file
- Create file format for the source file in DS (Source)
- Create a HANA data store for Target
- Create a Project
- Create a batch job
- Create workflow
- 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 Datastore for SQL DB (Source), Import required table
- Create a data store for HANA DB (Target)
- Create a Project
- Create a batch job
- Create workflow
- create dataflow
- Take SQL Table as a source
- Take Query transformation
- Take target table for HANA Datastore
- Execute Project
- HANA STUDIO
- Same as table
SAP BI TABLE
- Create DST for B1/BW Datastore (Source), Import required table
- Create DST for HANA (Target)
- Create a Project
- Create a 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 provides a name for the 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 the SAP HANA database 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 to upload data from a client system in the form of .xls, .xlsx, and .csv Compose the data: In composing we can combine two different databases by using joins and unions
For in-depth knowledge on SAP HANA, click on below
- Performance Tuning in SAP HANA
- Security in SAP HANA
- Analytical Privileges in SAP HANA
- SAP HANA Tables and Views
- SAP HANA Views