Dropdown with property values

[Former Member]

Hi Experts,

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.

AD

[former_member1242110]

the beter idea than dropdown is beter to use a EVPRO function in another cell.

by using the value we can expand the report .

can you share your report once...

thanks,

rajesh

[Former Member]

Hi,

A fairly simple way to do this would as follows:

1) Build an EVDRE on a hidden sheet, have all BASMEMBERS of the dimension you require in rows

2) Have EVPRO on each line of this EVDRE returning the property you require (=EVPRO(<APP NAME>,<CELL REF>,<PROPERTY NAME>)

3) On the main sheet have a cell (say in B1) with data validation (List), pointing to the EVPRO column of your hidden EVDRE

This will return all of the available property values in the dropdown box.

4) In the Expansion range of your main report enter something like ="BASMEMBERS AND <PROPERTY NAME>="&B1

Then based on what you pick from the drop-down box your report will refresh with.

Hope this helps.

Tom.