Skip to Content
Actions

Consumption of BW Models in SAP HANA

June 26, 2013 | 618 Views |
Follow RSS

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

To report this post you need to login first.

7 Comments

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

  2. Former Member

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

    (0) 
    1. Former Member 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.

      (0) 
      2. 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?

        (0) 

Leave a Reply