Consumption of BW Models in SAP HANA

Dear all,

Here i would like to explain about consumption of BW Infoprovider directly in SAP HANA without using Business Objects Data Services .

But we should have SAP HANA/BW landscape with BW 7.3 SP05 and SAP HANA 1.0 Revision 48 above.

Step1: SAP HANA Studion choose Modeler Prespective ->Import (or) Quick Launch -> Import .

Step2: As all are aware of different options available in Import ,need to select directly Import SAPNetweaver BW Models to connect to SAP BW 7.3 System.

Step3: For the first time need to Create New Connection and fill required generic parameters like Server Name, Host Name, Instance Number, Client Number with BW System User Name and Password as below.

Step4: Once System creates Connection Successfully, We need to mention Target System (Hana System)
on which the BW model has to be deployed.

Step5: Choose respective SAP HANA optimized Info cube from InfoArea. Here we can use either Info provider based analytical privileges or role based analytical privileges (i.e. specific roles assigned to a user) ,to include display attributes in the info provider and to overwrite existing objects.

Step6: Once it is finished it creates Analytical View suffix by Internal in the respective BW package as below.

7 Comments

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

Phani Rayasam Post authorJune 26, 2013 at 10:08 am

Pls let me know comments or additions to be made to this.

like (0)
Gabor Kovacs June 26, 2013 at 1:44 pm

Hi Phani,

Please refer to Note 1764251 – Documentation-
Importing BW Models in SAP HANA Modeler

This SAP Note always has the latest information regarding InfoProviders (InfoCube, DSO) and BW authorizations to HANA privilege, including restrictions/limitations.

Additional readings here:

http://www.saphana.com/docs/DOC-3151

http://www.saphana.com/community/blogs/blog/2013/06/20/a-flavour-of-the-hana-edw

http://scn.sap.com/docs/DOC-33716

Regards,

Gabor

SAP Customer Solution Adoption (CSA).

like (0)
Vivek Singh Bhoj July 26, 2013 at 4:14 am

Hi Phani,

On what basis does HANA create Analytic Views based on InfoProviders?

like (0)
1. Phani Rayasam Post authorJuly 30, 2013 at 10:38 am
  
  Hi Vivek,
  
  As of nowAnalytic views will be created based on Hana Optimised Infocubes and DSO’s .
  
  for Infocubes it generates analytical view prefixed with _internal and calculation view will be created internally but not consumed by user and even for Dso’s ,analytical views will be created on active table.
  
  like (0)
  1. Phani Rayasam Post authorJuly 30, 2013 at 10:39 am
    
    Thanks ,
    
    Phani
    
    like (0)
  2. Vivek Singh Bhoj July 30, 2013 at 2:53 pm
    
    Hi Phani,
    
    I know that but the thing is Analytic View needs Fact table – so which table acts as fact table and which table as master data table
    
    and in case of Infocube Analytic view uses which tables?
    
    like (0)
Veena R February 1, 2016 at 1:43 pm

Hi Phani,

Can we consume BW Multiprovider in HANA?

like (0)