Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
rohitchouhan
Participant
4,782


In Sap Analytics Cloud at times we need to update the master data for a model's dimension, so the developer can update it manually. However, how can we do this from SAC Analytical application?

There is an API called updateMembers()

using this API we can update members of any dimension, but note it: its only supported for generic dimension, not for version, account, date and organization

to call updateMembers() API we have to create Planning Model once, follow the below steps.

If you want to know how to create, update and delete master data using scripting, follow this blog or watch below video.



Syntex:-
g_properties = ({
id: "ID of MEMBER, TO UPDATE",
properties: {
PROPERTY_NAME: "VALUE TO UPDATE"
}
});
PlanningModel_1.updateMembers("DIMENSION_NAME", g_properties);

Example:-
g_properties = ({
id: "USA",
properties: {
CUR: "CA"
}
});
PlanningModel_1.updateMembers("MARKET", g_properties);​

 

1. Create Planning Model, and select your Model


 

2. Create new Script Object and select type as PlanningModelMembers



 

3. Create new button, go to edit script and paste code.





 

4. Run Application, and click on button, Property will update for USA currency USD to CA


 

Result in Present Mode:-



Conclusion


As a result, this article has explained how to update the master data of dimensions. However, sometimes dynamic updates are required as well. In such cases, Javascript is required.
2 Comments
Labels in this area