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.
- 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
In the “Mapping Menu “ -> Select as “One to One” and Store Type -> Select as ”Column Store”
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
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)
We need to create a new package (SALES_FINANCE) by providing package name , description , person responsible in SAP HANA Studio
We need to create a new Analytic View (SALES_ANA_VIEW) by providing analytic view name , package name , description
Click on “+” icon to Add Objects @ Data Foundation and search for the object name = VDITM
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
We can see the added objects highlighted in orange color and also in the “Output” pane under “Columns” folder.
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)
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).
We can now “Data Preview” in many formats like Charts , Table , Grid , HTML along with option of find Distinct Values in the Raw Data.
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