3752707 - Unable to pass variable values via a url when the story uses more than one SAP BW Query in SAP Analytics Cloud (SAC)

• Unable to pass variable values to multiple SAP BW Query used in a story using the URL API in SAP Analytics Cloud.
• When passing variables to the first model via a URL it works, but when adding parameters for the second model, the first model no longer receives the values.

SAP Analytics Cloud

1. Create a story that uses more than one SAP BW Query based on live data models where both prompt for at least two mandatory variable.
2. Configure a linked variable between the two models for only one variable, while other mandatory variables remain unlinked.
3. Open the story through the URL API and include variable parameters for both models in the url.
4. Notice the variable values passed in the url are not displayed in the variables prompt screen.

When a linked variable exists between the SAP BW Queries, but not all mandatory variables are linked, this linking inconsistency prevents the URL API variable parameters from being applied correctly across both models.

• Remove the linked variables between the SAP BW Queries (models) on the story:
    
  
  1. In SAP Analytics Cloud, open the story in Edit mode.

  2. In the toolbar at the top, select: "Tools -> Edit Prompt…"

  3. In the menu that display, select: "Link Variables…"

  4. In "Link Variables" click on the garbage icon on the right to delete the variable links.

  5.  Click “OK”. when prompted by:  "Are you sure you want to remove this variable link?" 

  6. Back to the screen "Link Variables", click: "Done"

  7. Save the story.

sac, url api, variable parameters, multiple models, variables not passed, linked variables, mandatory variables, bw query, live connection, story variables , KBA , LOD-ANA-DES-URLAPI , SAP Analytics Cloud Story related URL parameters API , Problem