Skip to Content

This document is valid  for SAP BW on HANA 7.4 installed on the server with packages sp5 and above:

In the current era of advance versions of  BW on HANA or native HANA , we may not find the old BW objects like Infocubes, Standard DSO, Infobject etc. anymore in  future days of  data modeling . But until all SAP BW projects move to BW on HANA 7.5 ( or above)  we have the relevance of consuming those BW objects in SAP HANA .

This document is  more pictorial self-explanatory presentation

From BW on HANA 7.3 release we have the feature of consuming BW objects into SAP HANA directly.

From BW 7.4 onwards automatic HANA view creation is also available from SAP BW workspace.

There is automated way to get all info providers to be available in HANA studio as views, we need to just enable the check box as shown in below screen shots.

View would be generated in hana studio in “System-local–> BW2HANA>>BW Package.

There are 2 ways to use BW objects in HANA studio

1) By Enabling the checkbox of External HANA View in  BW object Settings

2) By Manual import  of the objects in  HANA Studio

This document will depict  step by step approach , how we can achieve that

1)      By Enabling the  checkbox of External HANA View in  BW object Settings:

a)      Infoobject:


External SAP HANA view for master data :  To generate Attribute view

        External sap HANA view for Master Data Infoprovider  :  To generate Analytic view


Infoobject as Master Data:

Go to the Master Data tab of Infoobject

Step1.jpg

Infoobjet as Infoprovider:


Test infobject is appeared as Attribute view in  “System-local–> BW2HANA>>BW Package under the Attibute View.


When Infoobject is used as Infoprovider it will appear under Analytic Vie folder




Step2.jpg

b) DSO :

  • For DSO and Infocube a new checkbox is made available in  the settings tab “External SAP HANA view for reporting”. If this flag is set accordingly, an external SAP HANA analytical view is generated automatically with the activation of DSO.

Step4.jpg

c)       Composite provider:

At the time of creating Composite Provider from SAP BW modeler perspective of HANA Studio , we have to tick the check box of external SAP hana view . A calculation view will be created automatically .

Step5.jpg

d)       Infocube:

Same as DSO – Analytic view will be created under the Analytic folder in HANA .

Below settings we need to do in BW

Step6.jpg

e) BeX Query:

You can expose the Query directly as a SAP HANA view, no need for replication.

Goto TCODE :RSDDB Choose  Quey as infoprovider ,

click on  Release Query as infoprovider

then  create

go to SAP HANA/BWA Settings Tab

and  enable the External HANA Repository view  , then Activate and fill index.

Step8.jpg

2)      By Manual import  of the BW objects in  HANA Studio:

We can directly import the BW objects directly in HANA Studio.

At the time of importing the Info cube  we  need to choose any  Package whatever available in HANA . It will create one  Calculation View and one  Analytic view in the respective folders for Analytic view and Calculation view.

step lmport.jpg

Step9.jpg

In case of DSO if we import from BW it will create Analytic view only.

If it is Infoobject it will create an Attribute view after importing into HANA

Without importing the BW objects in  BW-HANA Modeler perspective, we can also directly add  any BW objects into any of the Views ( CALC, AN, AT ..) See below in the plus sign marked in the canvas. We will get all available BW objects in the form of tables.

We have to add the BW objects as ( P-table, A-table( Active Data table), F-table, D-Table….)

Step10.jpg

If you add the P tables, A tables etc. you need to maintain the text description manually using joins with other required text tables.

To report this post you need to login first.

9 Comments

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

    1. Ganesh Thota

      If you would like to create virtual cube in BW on top of HANA views, based on a SAP HANA model, click details, new screen will pop up and F4 on package will show all the packages of the attached HANA system, you will find the HANA views under those packages, else do you an F4 on HANA information model.

      Hope this is what you are looking for. Else please post your question with more details.

       

      ~ Ganesh

      (0) 
  1. Akshay Bhandari

    Hello Prasun,

    I have one query. We have created an ADSO in Bw and tried importing the objects in Native Hana. But during importing of objects I am unable to locate the same? Standard DSO objects we can find the import screen

    Also we have the SAP HANA  and SAP BW maintained in two different servers and both of them have a different IP address.

    Could you put ur thoughts on the issue.

    Regards

    Akshay

    (0) 
    1. Ganesh Thota

       

      As per SAP Import of  BW Objects is limited only for Info cube, Master data, Standard DSO.Alternatively you can have  the HANA view generated as Calculation view by checking the ‘External HANA View’ when you create ADSO from BW perspective. You will find the generated HANA view under System-local–>BW–>bw2hana–>calculation views

      https://help.sap.com/viewer/52715f71adba4aaeb480d946c742d1f6/2.0.00/en-US/4cbc34af5f1546e6b4dfb8fb05f25bca.html

       

      ~ Ganesh

       

       

      (0) 
  2. Ganesh Thota

    Good Document Prasun Saha !!..Is there any settings for the query to appear in RSDDB transaction. in Query as info provider, if I do an F4 on Query I do not find all the queries in the system.

    (0) 
  3. Rahul Rai

    Hi,

     

    A good document to understand different options for using BW models in HANA views. I would request you to remove the last portion, about using the tables directly, from this blog. SAP does not recommend that method and we have very recently learnt with our project that utilizing tables can result in faulty numbers after the system upgrade.

    1682131 – SAP BW tables in SAP HANA Information Views and ABAP CDS Views not supported
    has the official statement for that case

     

    Thanks,

    Rahul

    (0) 

Leave a Reply