Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

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 : 

  • 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"

In the pop-up window : Select & Expand "SAP HANA Content" folder -> Select "Data from Local File" option -> Click "Next"
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

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

Labels in this area