Skip to Content

SAP Analytics Cloud write back to BW

Hello,

I was wondering if there is a way to write back Data to SAP BW from my SAP Analytics Cloud. What I want to this is this:

I am importing the Data from BW/4HANA via a Data Import Connection into the SAC then use the imported data for Planning (for example planning using Workflow) and then want this data written back to my BW/4HANA.

I know that currently there is no export connection available for the BW but is there a way or workaround to write the data back to BW?

Thank you for any Insight and help you can provide me with on this.

Regards,

Florian Ullrich

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Dec 12, 2019 at 01:42 PM

    Not tested, but 2 ways should work:

    a) Export data via OData services

    b) Export Model as File

    Both sources should be possible to load in BW.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 20, 2019 at 08:24 AM

    I see "Export to SAP BW" is on the roadmap for 2020 Q1

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 26, 2019 at 03:57 AM

    Hi Florian,

    I used write back functionality using HANA database with Live Data connection but with BW. I am also waiting for Q1 2020 if such functionality will come.

    In HANA we can easily achieve it my HANA XSJS.

    Regards,

    Sanjay Guha

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 13 at 06:09 PM

    Hi Florian,

    This is possible by default if you have an embedded BPC model and connect your input ready query to SAC via live BPC connection.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.