Implementing Cascading Filter Dropdown for Date Dimension properties in SAP Analytics Designer

[pooja_elangovan01]

Hello Community,

I am currently working on a dropdown feature that involves displaying all properties of a date dimension in SAP Analytics Designer. I would like to implement a cascading filter dropdown or a radio button group that dynamically lists the members of the selected property, such as half-year (e.g., H1, H2). The objective is to populate the selected member into a table column. Could you please provide guidance on how to achieve this?

Thanks in advance.

Regards,

Pooja.

//Dropdown code that I have implemented for displaying all the properties of date dimension:
var Date_Properties = Table_1.getDataSource().getDimensionProperties("Date");

for(var dp=0; dp<Date_Properties.length; dp++){

if(Date_Properties[dp].description ===''){

{DD_Properties.addItem(Date_Properties[ap].id, Date_Properties[ap].description);}

}

else{

{DD_Properties.addItem(Date_Properties[ap].id, Date_Properties[ap].description);}

}

}