3705196 - Failed to Fetch Data Error When Using Hierarchy Prompts in SAP Analytics Cloud

• When opening a story with predefined prompts, the table displays the error message "Failed to Fetch Data".
• Clearing the hierarchy variable prompt value and running the story. User observes data appearing.
• Now editing the prompt to re add the cleared variable returns expected data.
• Saving the story with the reselected prompt value and reopening it results in the same "Failed to Fetch Data" error.

SAC Analytics Cloud

1. Access the story and click "Set" for the predefined variables.
2. Observe the "Failed To Fetch Data" error in the table.
3. Remove the value for the Hierarchy prompt variable and click "Set".
4. Verify that the story returns data.
5. Re-add the removed variable value Hierarchy prompt and click "Set".
6. Confirm that the expected data appears.
7. Save the story with the reselected prompt value and reopen it.
8. Observe the "Failed To Fetch Data" error reappears.

• The issue is currently under investigation by Development

• The issue is currently under investigation by Development

failed to fetch data, profit center hierarchy, hierarchy issue, sap analytics cloud, BW notes, story prompts, variable profit center, CHS consolidated, BRAIN643, hierarchy prompt error, data visualization, story error, BW live connection , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem