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
2,832
In Sap Analytics Cloud, while we enter any data in table, so we have to publish data it also to Model, in normal canvas story its easy to do, but in Analytical Application if we want to publish data with Button trigger so you are in right article, just follow the article.

Publish Fixed Version Data


Create a new button, in your analytical application from Insert > button,

1. Go to code editor of button by click on Edit Scripts > onClick

1.png

2. Write this mention code, replace version with your version member's description, like Actual, Current , don't use id (public.Actual) like that.
Table_1.getPlanning().getPublicVersion("Actual").publish();

3. Save it, and Run

 

Publish Data with Table Filter Automatically


For getting automatic version from table, when you apply filter, just use code mention below.

1. Create Planning Models from left sidebar, select your model

2. Create button, and add this code to your button onClick(), replace SCENARIO with your Version's Dimensions name.
Application.showBusyIndicator();

var planning = PlanningModel_1.getMembers("SCENARIO");
var s_filter = Table_1.getDataSource().getDimensionFilters("SCENARIO");

for (var i = 0; i < s_filter.length; i++) {
if (s_filter[i].type === FilterValueType.Single) {
var scenarioValue = cast(Type.SingleFilterValue, s_filter[i]);
}
}
var checkScenario = scenarioValue.value;

for (var j =0; j<planning.length;j++){
if(planning[j].id === checkScenario){
var scenario = planning[j].description;
}
}

Table_1.getPlanning().getPublicVersion(scenario).publish();
Application.hideBusyIndicator();


Conclusion


Sap Analytics Cloud, when you modify a table and need to publish it, there is a button Publish Data in the top bar. But sometimes you might need to publish data from an existing button that was created by a user. So you can use this method for publishing data from a button trigger.
Labels in this area