Any Write Back functionality at Datasphere (DWC)?

[satrajit_chatterjee]

Hi Experts,

We're currently utilizing Datasphere (DWC) as our backend data warehouse, and we've employed SAC as our frontend reporting tool. A new business requirement has arisen, wherein users need the capability to rectify entries (update in analytics report and save) within the analytics reports. However, upon investigation,

I haven't come across any inherent write-back feature within the DWC tools. I'd greatly appreciate your insights on how we might be able to implement this functionality for our customers.

Your suggestions are most welcome.

Regards

Satrajit

[PRAT280]

Hi,

We are on or way to have a seamless integration between SAC and DS. For now, this is how you can architect it

1. Create a planning Model in SAC (same structure as you have in analytical story)

2. Load data from DS into this model

3. Create Input story (input form) on this model (Business Users can enter/modify the data using this input story (input form)

4. Export adjusted data from SAC to DS

5. Combine view on Original and adjusted data

6. Create a story in SAC on this view

You can refer the previous answers to create the connection to import and export data from SAC to DS.

I hope this helps

Thanks

[amlan_dhow]

Along with the use of SAC planning, another alternative option might be explored by using of SAP BTP front end Fiori tool which may read data from table and allow user to update data in same table.

[JulianJuraske]

As already mentioned by Nikhil, when using SAC I'm also only aware of the SAC Planing with the Data Export API, since SAC itself is a visualization Tool.

Otherwise the DSP is wide open to recieve any Data from any Source via the Open SQL Schema.
Have a look at this Blog that explains the DB Explorer Function of the DSP, this may help you better understand your Possibilitys when using DSP.

[N1kh1l]

satrajit_chatterjee

satrajit_chatterjeeI am not sure if SAC Analytic model allow updating of values. I think its possible in SAC Planning Models. SAC Planning model do have Data Export API options which can send data back. The below can help.

Extending SAC Planning – Acessing planning data with SAP Datasphere | SAP Blogs

Using the SAC Data Export API with Datasphere and Data Intelligence | SAP Blogs

Also the below note has some guidance

3304951 - Checkpoints: Data Integration Between SAP Analytics Cloud (SAC) Data and SAP Datasphere(DS...

Hope this helps !!

Please upvote/accept if this helps

Nikhil