SAP Knowledge Base Article - Public

3410751 - SAC Analytics Designer :Input Control shows "undefined" and "no value" instead of ID (SAC LOD-ANA-AD)

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

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

Product

SAP Analytics Cloud all versions