Dropdown Lists
Dropdown Lists are interactive UI components in Analytic Applications that allow users to filter, drill down, or dynamically change data in charts and tables.
They are implemented via scripting (getMembers, addItem) to enable features like cascading filters (e.g., selecting a country updates a city dropdown) and dynamic dimension switching.
From a technical perspective, dropdown lists can be bound to dimensions, BW variables, or script-controlled value sets, enabling advanced behaviours such as cascading filters, dynamic member restriction, and runtime control via scripting APIs.
This makes them a key building block for creating responsive, user-driven SAC stories that balance flexibility with governance.
Script Examples
-
Switching Dimensions in/out of a table on specific rows
-
Switching Measures in/out of a chart using a dropdown list
-
Mutually Exclusive Dropdown Lists
-
Populate a dropdown list with all dimensions from the underlying model
-
Switching Measures in/out of a table using a dropdown list
-
Handling undefined values in a dropdown
-
Apply a dimension filter using a dropdown list without triggering a data source query
-
Restrict dimension members in a dropdown based on another dimension filter(cascading)
-
Populate a dropdown list with Members of a Dimension from a specific level in a hierarchy
-
Populate a dropdown list with members of a measure
This example is part of a broader set of SAP Analytics Cloud scripting patterns, covering common use cases such as filtering, measure switching, and reacting to user selections.