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.

[N1kh1l]

pooja.elangovan01

Do you have dropdown for Brand and Category already populated ? Once Brand and category is selected in dropdown, you want to filter your table with all master data members of BPP where Brand and category attributes are same as dropdown selections ? Also is the model involved a planning model ?

Is my understanding right ?

Nikhil