Create Simple View From Different Sources in SAP HANA

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 the 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, and 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 data files take Query transformation, connect Query transformation to ABAP dataflow map all fields whatever you want, map Query transformation, and 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 modeller (Studio)

Go to modeller quick launch

Click on SQL editor

Enter the Query

[Create Schema <schema name>]

Expand system catalog (We have created a target HANA table under the system catalog in Data Services)

Select our table, right-click and select a new view

On the Right side will get a table

Drag columns to the 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 this in 2 ways

1) Tables

2) C ports

Right-click a 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 values in a column

3) Analysis            It displays data in the form of tables or charts based on selected  Objects, and 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, and 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

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 a 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 provides 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 the 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, and take transport connection, in query transformation map all fields (if there is no primary key), and the 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 that 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