Update master data of dimension using JavaScript i...
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!
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?
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);
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.