Cascading dropdowns in SAP Analytics Cloud (SAC) Using Script : SANJEEV SINGH скачать в хорошем качестве

Cascading dropdowns in SAP Analytics Cloud (SAC) Using Script : SANJEEV SINGH

Concept : In SAP Analytics Cloud (SAC), cascading dropdowns create dependent filters (like Region - Country - City) by using scripting in Analytics Story , you add dropdowns, use the OnSelect event of the parent dropdown to filter the data source or query for the next level, then dynamically populate the child dropdown with filtered members using methods like addItem and clearing previous items. This links selections across widgets, allowing users to narrow data progressively. Logic: The selection in one dropdown (parent) is used to filter the data source for the next dropdown (child). Implementation Steps: • Add the desired number of Dropdown components to the canvas. • Define global variables to store the selected values and the list of values (LOVs) at runtime. • In the onInitialization event of the application, write JavaScript code to populate the initial (parent) dropdown with all values. • In the onSelect event of each parent dropdown, add a script to filter the data source of the child dropdowns based on the newly selected value. This uses the dataBind method or similar functionality in the SAC API.