mobileNavlogo
headerlogo

Blog

Implementation of Projects in SAP Hana

22 September, 2020

Related Blogs

Implementation of Projects 

Project 01:

Load, cube data from BI ----------- HANA DB:- (Delta)

Create Datastores for SAP BI source

Create Datastores for HANA DB

 Steps at BI Level:-

Select any cube & cheek whether data is or not in data

Go to the provider (tab) in T-Code RS4.1

Go to open hub destination (tab )

Provide

  • Name : ___________
  • Description: ___________
  • Provider : __________ (Technical name of web, Dso’s & etc)

In the next screen in the destination (tab) provide

Destination type: Third part tool

RFC destination: RFC connection of (DATA services)

Activate

  • Create Transformation b/w cube & open hub
  • Create DTP & activate

NOTE: DTP extraction mode must be in delta

  • Go to process change (tab)
  • Right-click on unassigned note create process change & provide process name, Description and will get prompt start variant click on create
  • Next screen

Start using meta chain or API

  • Save ---- Go back
  • Select our DTP ------- connect to start variant & activate

Steps at Data Services:

  • Import open hub destination into BI source datastore
  • Import database table from Hana datastore
  • create a project
  • create Job
  • create workflow
  • create Data flow
  • drag OPA hub open hub
  • Double click on it
  • read from process change
  • select other process change
  • Take Query transformation
  • connect open hub transformation
  • Drag table from the open hub
  • connect Query  transformation from Hana table
  • And Map fields of open hub & fields of HANA database table.

NOTE: Open hub brings updated Read-only to execute the job  

Checkout Our  SAP Hana Tutorials

Project 02:

sap hana project 02    

Project 02: Load data from the traditional database (Non-SAP system) To Hana database (initial & delta)

sap hana project 02  

STEP 1:

  • Create a view job
  • Go to the source database
  • Create a table called CDC – Time with CASTY – update column with data time data type and import source table and CDC Time table into data services

STEP 2:

  • Create a project
  • Create a job
  • Create variables (global variables) (4) $GV – Start time
  • $ ar – end time with data time data types

Step 3:

  • Take 2 scripts to name it as INITIAL – START and INITIAL – END
  • Take a new workflow and put in between two scripts
  • Double click as INITIAL – START Script go-to smart editor and write the below syntax
  • $GV – STARTIME = ‘1996.01.01              
  • 12.00.00’, $GV – ENDTIME = system ():
  • Double click as INITIAL – END Script, to go smart editor and write the below system
  • SQL (‘cdc’, ‘DELETE FROM CDC – TIME’ ); SQL (‘cdc’, ‘INSERT INTO CDC – TIME VALVES (S$GV – ENDTIME);

Step 4:

  • Double click as workflow
  • Create data flow
  • Select the source table (i.e.) employer table
  • OPS -  EMPLOYEE (CDC)

sap hana  

  • Take Query transformation, map source table to Query transformation
  • Take the template as target table, map it to Query transformation

Step 5:

  • Double click on Query transformation
  • Map the required fields from schematic to schema out
  • Select LAST – update column
  • Go to where clause and provide the logic as below
  • (ODS – EMPLOYEE. LAST – UPDATE >$ GV – STARTTIME) And (ODS – EMPLOYEE. LAST – UPDATE < $GV – ENDTIME)

STEP 6:

(HANA) Table

If you want to enrich your career and become a professional in SAP Hana, then visit Tekslate - a global online training platform: "SAP Hana Administration Training"   This course will help you to achieve excellence in this domain.

  • Take as target table, connect it to Query
  • Double click as the target HANA table go to the options tab, enable delete data from the table before loading checkbox and enable drop and created table cheek box

Step 7 :

  • Validate
  • Extract the job and you can see in the source system in CDC – Time table there is a time stamp loaded which is nothing but INITIAL load time

DELTA LOAD:-

  • Create a new job name as a delta load.
  • Take two scripts it as initial START and INITIAL END.
  • Take a new workflow, put it in between two scripts
  • Double click on initial START Script and go to the smart editor provide below logic
  • $av – STARTTIME = to-date (Sqc (‘cdc’, ‘SELECT Last – UPDATE From CDC – TIME), ‘1996.01.01            
  • 12.00.00’), $av – ENDTIME = sysdate ();
  • Double click on end script and go to import editor provider below logic,
  • SQC (‘cdc’, Update CDC – TIME SET LAST- UPDATE= {$av – ENDTIME});

sap hana   sap hana  

  • Take employee table as a source table
  • Take Query transformation and connect both
  • Double click on Query transformation, map the required fields from schema – into schema out
  • Take the HANA table as a target table
  • And make sure that in the target HANA table options tab, Disable the following checkboxes
  • Delete data from the table before loading
  • Drop and recreate a table
  • Validate it
  • Execute the Job

         

About Author
Authorlogo
Name

TekSlate

Author Bio

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 .