Symptom
· When running the data action button in the story, the manufacturing value appears in an incorrect currency.
· The expected result is for the value to be displayed in SEK, but it is instead shown in EUR. The value seems to change inconsistently based on user interactions.
Environment
SAP Analytics Cloud
Reproducing the Issue
-
Open the story containing the data action.
-
Apply the same filters as originally used and ensure the Version selected is "example"
-
Modify the numeric values in the Additional MC lines.
-
Click the Calculate COGS trigger at the top of the page.
-
Observe that the manufacturing value is displayed in EUR instead of SEK.
Cause
• This issue occurs due to the behavior of private versions during data entry.
• When a data entry is made on a public version, a private version is automatically created.
• The currency format (Default or Local) of this private version depends on the cell where the data was entered.
• The data action runs on this private version without publishing it first.
• As a result, the currency configuration in the data action setup (Default vs Local) is ignored, as documented in the tooltip next to the currency input in the data action configuration.
Resolution
To ensure the data action runs correctly with the desired currency (e.g., SEK), the version must be published before executing the data action. This can be done in two ways:
-
Manually publish the version after editing.
-
Automatically publish the version using a step in a Multi Action.
This ensures that the data action executes on a consistent version in the correct currency context.
Keywords
SAP Analytics Cloud, data action, currency mismatch, private version, publish version, local currency, default currency, multi action, manufacturing value, version control , KBA , LOD-ANA-PL-DA , Data Actions , Problem
SAP Knowledge Base Article - Public