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.

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

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

Create Simple View From Different Sources in SAP HANA