Is it possible to write data back to BW on HANA via XS ?

[anindya_bose]

Dear experts

In one complex requirement , I was trying to find out if it is possible to use some new features of BWonHANA and write data back to BW database or any table in ABAP dictionary ( and in turn read from that table to merge the data with BW Objects).

Like what we do in case of Integrated Planning where users can come and change some numbers , can we achieve that via XS ?

Regards

Anindya

[Former Member · Accepted solution]

Hi Anidya,

please distinguish  between the approaches:

a) SAP BW classic, InfoProvider, Metadata Rich Modelling

and/or

b)SAP HANA Database native modelling

and/or

c)SAP BW hybride modelling

a) not possible to write  to SAP BW InfoObjects/InfoProvider, due to SAP BW metadata SID Generation

a) only possible if You feed in data from a (native) table via upload to a SAP BW InfoObjects/InfoProvider

a) only possible if You use BW IP

a) Reading from BEX easy query possible via SAP Gateway

b)Possible , XS Service, UI5, ODATA, HDBC, any SQL Interface is used

c)Wirte back Yes if

- integration is going up from HANA database to SAP BW classic, InfoProvider, Metadata Rich Model layer, with methods of b)

Best Martin

[Former Member]

Hi Anindya,

if i understand correctly, you want to load some data to HANA database using XS and the same have to be merged with BW objects?

if so, yes we can store it in HANA scheme and create HANA views on top of this table and publish this hana model in BW which will be available as Transient provider and can combine with other BW objects usign composite provider.

Is this what you are looking for?

Also which version of BW 7.3 or  7.4 ?

Regards.

Sakthi.

[anindya_bose]

Hi Sakthi

I am on BW 7.3 . 

[Former Member]

Hi Anindya,

    If you are at HANA SP6 you can write back the data to HANA using XS.

As explained by Sakthi you cannot write back the data to BW directly using XS,write to HANA use it in any views and then consume that view in BW via virtual cube or transient provider.

If you are in BW7.40 then via ODATA service you can write the data back to BW.

Hope this answers your query.

Thanks & Regards

   A.Dinesh

[Former Member]

Hi Dinesh,

no way arround but haveing an HANA Database in reach and working through the  Open Sap Course:

Introduction to Software Development on SAP HANA - Thomas Jung

and than You have got it all

Best Martin