3706194 - Selecting certain variables is ignored/overridden at runtime in story in SAP Analytics Cloud (SAC)

• In SAC Story (live connection to S/4HANA analytical query), selecting a Variable Set that includes Plan Category is ignored/overridden at runtime; SAC appears to default back to another Plan Category.
• Data Analyzer with the same live query and variables works as expected.

SAP Analytics Cloud (Enterprise)

1. Log on to SAC.
2. Open story.
3. Set variable values.
4. Filter on specific Cost Center.
5. Notice that compared to the S/4HANA side with the same selection, this value differs.

• The data difference occurs because the table widget in your story is configured to use its own widget-level variable, which overrides the story-level variable.
• When you set or change the story-level variable, it does not apply to this particular table widget -> the widget continues to use its locally defined variable value, which differs from the one set at story level. 

To align the table widget with your story-level variable, switch its variable setting from "Set Table Variables" to "Use Story Variables". Once this change is made, any story-level variable updates will apply to the table widget as well, and the data will be consistent.

Steps:

1. In your story, select the affected table widget.
2. Open the table's prompt/variable dialog (via Edit Table Prompts).
3. Switch from Set Table Variables to Use Story Variables.
4. Save your changes and verify the data now reflects the story-level variable value.

• KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
• KBA 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• SAP Analytics Cloud Connection Guide
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support 

Your feedback is important to help us improve our knowledge base.