Symptom
- With a BW Live Model in Analytic Application (no optimized mode), when applying a BEx Variable using .getDataSource().setVariableValue("BExVariableName", VariableNameAsString) to a Table, after setting a Dimensionfilter to on the exact same dimension, the input control does not show ID, but it is displaying incorrectly the “undefined” and “(No Value)” instead.
Environment
SAP Analytics Cloud (Enterprise) 2023.8.8
Cause
The "Cascading Effect" option, which is enabled for all the Input Controls on the page, results in the selections made in one Input Control being used to filter the list of values which can be selected in other controls. It is intended to prevent users from making invalid selections when manually selecting values.
However, for the application, the "Cascading Effect" is preventing the setSelectedMembers function from updating the Input Control correctly.
(The reason that setSelectedMembers works the first time a selection is made in the table is because none of the Input Controls have any selections, so there is no "Cascading Effect" being applied. However, after that, the Input Controls will have selections and so the "Cascading Effect" will be applied.)
Resolution
The solution is to disable the "Cascading Effect" for all the Input Controls in the application that are being updated using the setSelectedMembers function.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using SAP for Me, Google or Bing:
- https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
Cascade effect, InputControl, Input Control, setSelectedMembers, getDataSource, setVariableValue, Analytics Designer , KBA , LOD-ANA-DES-FILBMK , SAP Analytics Cloud Classic Story Filters and Bookmarks , LOD-ANA-AD , Analytics Designer , Problem