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.
Pls let me know comments or additions to be made to this.
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).
Hi Phani,
On what basis does HANA create Analytic Views based on InfoProviders?
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.
Thanks ,
Phani
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?
Hi Phani,
Can we consume BW Multiprovider in HANA?