Question Re: SAP Analytic Cloud - Insert data into planning model in Technology Q&A

SAP Analytic Cloud - Insert data into planning model

chi_chiu_wong — Thu, 03 Jun 2021 21:10:34 GMT

Dear SAC Experts,

I had recently received a request from a customer for insert data for planning on SAC.

Customer wish to update the planning data with dimensions and measures.

For instance, the customer wish to update data based on a dimension budget code and change the dimension value of the following dimensions:

i. Priority - select available dimension value ( Onhold, Preferable, Upgrade, Required )

ii. Completion date - select a date from calendar

iii. Detail - input free text to update Budget Code Detail

iv. Project Nature - select available dimension value (IT Project, Software, Hardware, General).

I already tried and checked that standard features not able to achieve the request.

Please advise if you know there is any alternative (i.e. scripting) and provide some example script for update planning data with dimension value.

Thank you for your help in advance.

Regards,

Billy

chi_chiu_wong — Thu, 03 Jun 2021 21:12:41 GMT

For your information, the customer rejected for using excel upload to SAC.

I want to see if there is any alternatives before reject her request.

former_member6443 — Fri, 04 Jun 2021 01:02:53 GMT

Hi Billy,

This can be achieved by triggering a Data Action to update the Value in the Model based on a Attribute.

More information here

Also to update the Members you can use updateMembers to do the same.

I hope this helps

Regards

Afshin

chi_chiu_wong — Sun, 25 Jul 2021 04:54:20 GMT

Thank you for your feedback.

I will try the suggestion.