Skip to Content
Author's profile photo Former Member

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 .

modelbasic.JPG

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.

Model1.jpg

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.

/wp-content/uploads/2013/06/model2_236972.jpg

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

/wp-content/uploads/2013/06/model4_236985.jpg

/wp-content/uploads/2013/06/model3_236973.jpg

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.

/wp-content/uploads/2013/06/model5_236986.jpg

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

/wp-content/uploads/2013/06/model6_236987.jpg

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Blog Post Author

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

      Author's profile photo Gabor Kovacs
      Gabor Kovacs

      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).

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj

      Hi Phani,

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

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      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.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks ,

      Phani

      Author's profile photo Vivek Singh Bhoj
      Vivek Singh Bhoj

      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?

      Author's profile photo Former Member
      Former Member

      Hi Phani,

      Can we consume BW Multiprovider in HANA?