Skip to Content

Applies to:

SAP BW 7.3 SP 08 and SAP HANA 1.0 SP5

Summary

We tried to share our experiences while working on a proof of concept on how to model & consume SAP NetWeaver BW and SAP HANA Models using Transient Provider & Composite Providers.

Authors: Ravindranath Singh D (HCL Technologies)  and Raja Sekhar A ( CPM Consulting)

Created on:  26-Jan-2014
Authors Bio :

  • Ravindranath Singh is working as Group Project Manager with more than 10+ years of experience with expertise in the areas of SAP BW/BI , BOBJ,BODS  &  HANA and currently working with HCL Technologies.

  • Raja Sekhar is working as Senior Consultant with more than 7+ years of experience with expertise in the areas of SAP BW/BI , BOBJ, BPC & HANA and currently working with CPM Consulting.

Scenario : 

Data Flow.jpg
  • Two flat files which consisting of Sales Data and Finance Data respectively
  • Import flat files data into SAP HANA tables
  • Create Analytic View based on SAP HANA tables
  • Create Analytic Index / Transient Providers on Analytic Views by Publishing to BW
  • Create Composite Provider and BEx Report
Start -> Programs -> SAP HANA -> SAP HANA Studio -> Select  “Modeler” Perspective  -> Click on “Import”
/wp-content/uploads/2014/01/1_372137.jpg
In the pop-up window : Select & Expand “SAP HANA Content” folder -> Select “Data from Local File” option -> Click “Next”
/wp-content/uploads/2014/01/2_372138.jpg
Select the Sales Data flat file to be imported into the custom table name “VDITM”  by providing other details like  Schema , path of flat file as shown below :
Note : We can use CSV or Excel File (Office 1997 or above) to upload data
/wp-content/uploads/2014/01/3_372142.jpg

In the “Mapping Menu “ -> Select as “One to One”  and  Store Type -> Select  as ”Column Store”

/wp-content/uploads/2014/01/4_372143.jpg

/wp-content/uploads/2014/01/5_372149.jpg

/wp-content/uploads/2014/01/6_372150.jpg

We have to define Key, Not Null , Default Values as per requirements. (i.e. We have defined ZBILL_DOC & ZBILL_ITEM as Key fields for table VDITM.

In some cases ,we may need to check the data type proposed by the system and  manually update the data type of info objects based on the flat file data so that no errors related to data type inconsistency occur during data upload.

Note : The Data Type , Length , Scale for the info objects would be proposed by the system based on the data in the flat file to be imported. In SAP HANA , we have data types like TINYINT,SMALLINT,INTEGER,BIGINT, NVARCHAR, DECIMAL,REAL ,FLOAT, DOUBLE, DATE, TIME, TIMESTAMP, BLOB, CLOB,NCLOB, BINARY,VARBINARY ,ST_POINT, ST_GEOMETRY

/wp-content/uploads/2014/01/7_372151.jpg

/wp-content/uploads/2014/01/8_372152.jpg

/wp-content/uploads/2014/01/9_372153.jpg

We can see in the above step from the Job Log that the current job type of Importing data from local file has been completed successfully.

Following the above steps , we have successfully imported the both Sales Data & Finance Data flat files data into the custom table name “VDITM” & “FIAR” .

( For FIAR table , we have considered Reference Document Number and Item Number as the Key Fields)

                /wp-content/uploads/2014/01/10_372154.jpg/wp-content/uploads/2014/01/11_372155.jpg

We need to create a new package (SALES_FINANCE) by providing package name , description , person responsible in SAP HANA Studio

/wp-content/uploads/2014/01/12_372156.jpg

/wp-content/uploads/2014/01/13_372157.jpg

We need to create a new Analytic View  (SALES_ANA_VIEW) by providing analytic view name , package name , description

/wp-content/uploads/2014/01/14_372158.jpg

/wp-content/uploads/2014/01/15_372159.jpg

/wp-content/uploads/2014/01/16_372160.jpg

Click on “+” icon to Add Objects @ Data Foundation and search for the object name = VDITM

/wp-content/uploads/2014/01/17_372161.jpg

/wp-content/uploads/2014/01/18_372162.jpg

We can now select the requisite info objects from Data Foundation Layer to be used as part of the Analytic View by using “Add to Output” option

/wp-content/uploads/2014/01/19_372163.jpg

/wp-content/uploads/2014/01/20_372164.jpg

We can see the added objects highlighted in orange color and also in the “Output” pane under “Columns” folder.

/wp-content/uploads/2014/01/21_372165.jpg

We have to define the type of each info object whether it is a Characteristic (i.e. Blue Color) and Key Figure (i.e. Orange Color)  including Aggregation  details

etc. Click on “Save & Validate” and “Save & Activate” icons respectively.

Note : We need to maintain the name of all the info objects in Analytic View to be in Upper Case and no spaces are allowed etc.

(i.e. It gives error during validation if the name of the info objects are not in Upper Case and spaces exists in the name of info objects)

/wp-content/uploads/2014/01/22_372166.jpg

/wp-content/uploads/2014/01/23_372167.jpg

/wp-content/uploads/2014/01/24_372168.jpg

We can see in the above step from the Job Log that the current job type of activation of  Analytic View has been completed successfully.

Following the above steps , we have successfully created , validated and activated both Sales Analytic (SALES_ANA_VIEW) View & Finance Analytic View (FINANCE_ANA_VIEW).

/wp-content/uploads/2014/01/25_372169.jpg

We can now  “Data Preview” in many formats like Charts , Table , Grid , HTML along with option of find Distinct Values in the Raw Data.

/wp-content/uploads/2014/01/26_372170.jpg

/wp-content/uploads/2014/01/27_372171.jpg
/wp-content/uploads/2014/01/28_372172.jpg

We need to Publish the SAP HANA Analytic Views to SAP BW by using standard program -> RSDD_HM_PUBLISH

To be continued in SAP NW BW and SAP HANA Models (Part : 2 ) – Transient & Composite Providers

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply