3147048 - Embedded SAC Refresh button does not update the data

Symptom

You have made a modification in a certain characteristic/dimension, such as changing a description for instance, and you notice that by using the SAC Refresh button the change does not reflect on the Table/Chart.

Only by using the F5 (page refresh button) the Table/Chart has the values updated according to modifications made on the characteristic/dimension.

Environment

SAP Analytics Cloud

S4 On-Premise Live Connection

BW Live Connection

Reproducing the Issue

The scenario below is just an example. The same thing applies for different characteristics.

1 - Build a Table with Country (0COUNTRY) in Rows and any Measure in columns;

2 - Save the Story;

3 - Go to RSD1 transaction;

4 - Open 0COUNTRY and click on "Maintain";

5 - Change the Description of one or more 0COUNTRY's member;

6 - Save it;

7 - Back to SAC Story, click on the Embedded Refresh button;

8 - Notice that the Table does not bring the new description (defined in RSD1);

9 - Now click on the browser's refresh button or F5;

10 - Notice that the Table gets updated with the new descriptions;

Cause

This is by design. The Embedded refresh button does not request any MetaData, VariableSubmit or VariableDefinition backend call, thus the state of the data in the widget will be the same.

SAC with Live connection stores only metadata and metadata only, eg: measure names, columns names, filter values, etc. Basically, the metadata enables to rebuild query, but none of the actual data. Therefore to be able to have the newest data, use the browser's refresh button (F5). The same thing is valid for Analytic Application API .refreshData(), because they trigger the same function under the hood.