Symptom
BW variables are not applied when navigating to an SAP Analytics Cloud (SAC) Insight using NavigationUtils.openInsight() with URL parameters. Although the Insight opens successfully, the provided variable values are not passed to the target report, and the query is executed using default or backend-defined values instead.
Environment
- SAP analytic cloud
- BW live connection
Reproducing the Issue
- Create a story and add a button
- Link this code to the button: NavigationUtils.openInsight( "Insight_ID",
[ UrlParameter.create("parameter", "value")]
); - Click on the button
- The URL parameter is not handed over
Cause
The backend system requires parameter values in uppercase format, while SAC sends the values exactly as maintained by the user without any conversion.
Resolution
The behavior is caused by the backend system expecting the parameter values in a specific format.
SAP Analytics Cloud (SAC) does not convert parameter values to uppercase, it passes them exactly as entered by the user. Using uppercase values resolves the issue because they match the format expected by the backend system.
For example:
NavigationUtils.openInsight( "Insight_ID",
[ UrlParameter.create("parameter", "VALUE")]
);
See Also
Keywords
SAP Analytics Cloud, SAC, NavigationUtils.openInsight, openInsight() API, UrlParameter.create() API, BW variables, URL parameters, variable passing, Insight navigation, BW query, technical names, uppercase parameters, variable mapping, live BW connection, SAC scripting, URL parameter , KBA , LOD-ANA-UNS-SCR , Unified Story Scripting related Issues , LOD-ANA-DES , Story Design & Visualizations , Problem
SAP Knowledge Base Article - Public