Populate table and chart based on dropdown selection

[#1]

Hello Community,

I am currently working on an SAP SAC analytical application that involves a dimension called BPP, which has properties such as Brand, Category, Package, and more. I have a dropdown that includes specific properties of BPP, such as Brand and Category.

My goal is to dynamically populate the table and chart with brand members when a brand is selected in the dropdown. I am seeking an SAP SAC analytical application script for this query.

Thank you in advance for your help.

Regards,

Pooja.

[sourabhpaul]

Hi,

For this, you should implement cascading effect on dropdowns.

In the first dropdown, you should add only the brand and category. and in the next dropdown, you can add values according to the value selected in the first dropdown.

Regards,

Sourabh Paul