SAP Analytic Cloud - Insert data into planning model

[chi_chiu_wong]

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]

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]

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]

Thank you for your feedback.

I will try the suggestion.