Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Active Contributor
Hi Friend,

As we know there is no direct option to create a cascading drop down in SAP SAC Designer,

So i am writing the blog to explain the each step how to create a Cascading drop down in SAC Designer


Below are the step need to follow to implement the cascaded drop down in the SAC designer


Step 1           Add 3 drop down to the canvas

In this example we have 3 drop down for cascaded prompt

Product 1, product 2 and product 3

Given drop down name as below

      1. dropdown_prod1

      2. dropdown_prod2

      3. dropdown_prod3




Step 2          Need to add a chart to canvas to get the Drop down list of value at run time

In that chart also need to add the all 3 dimension in the chart as shown below



Step 3          After adding the data to the chart we need to create 3 global variable ( note                                          create an array to store all the LOV value in it at run time)

Need create 3 global variable array

3 global variable array name as below

      1. prod1_drop_dyn_array

      2. prod2_drop_dyn_array

      3. prod3_drop_dyn_array



The above array will be used to store drop down LOV which will be used in the filter further

create more 3 global variable

      1. dropdownprod1_Selectedkey

      2. dropdownprod2_Selectedkey

      3. dropdownprod3_Selectedkey




The above 3 global variable will be used to store the selected drop down at run time.



Step 4          on initialization we have to write a below code


up till now had assign the List of value (LOV) to the drop down and now see the ALL as default selected value in all 3 drop down.

Now below step is used to create a cascaded drop down in the application.



Step 5           Need to create global script object (function) for cascaded

 Below is the code will update a LOV of cascaded prompt base on the selection of drop down



Step 6              on each drop down we have to write a below code

This code will update the global variable

Below code in for prod1 on select script


As you can see i am calling a global script object (function) in the on select of prod1


Same code i had repeat for prod2 and prod3 drop down.


Below code is for Product 3 drop down.


Below code is for product 3  drop down



Note to apply filter to chart or table i had used a below 3 global variable array.

  1. prod1_drop_dyn_array

  2. prod2_drop_dyn_array

  3. prod3_drop_dyn_array


Thanks & Regards,

Saurabh S.
Labels in this area