How would you create a drop down on a report which contains all the values of a property for a given dimension.
My Account dimension has property called Allocation_Rule which could have Rule1, Rule2 ... values.
In my report i have to give the rule selection to the user so that when they pick a value i will have to expand evdre rows for accounts where the property is Rule1 or so.
Question 1: How would you create that dynamic drop down with property values
Question 2: How would you expand EVDRE based on the drop down selection.