Limit Results of Drop Downs Based on Valid Members

[DOC_89]

Existing customer is using Guided Reporting and has multiple Drop Down Boxes.

They would like to select the first Dimension's Drop Down Box (Entity) and only See valid choices for the second one. 

In their example, if they choose a Philadelphia Entity they only want to see the Departments (Ud2) that are valid for Philadelphia.

Is there tagging or another method where this can be done dynamically? Or worst case scenario, a hard coded list of what are valid combinations?

Thanks very much.

[db_pdx]

Hi doconnel: yes this is possible using the TextN fields of the target dimensions and member filter logic.

An example layout would look as follows (this assumes usage in a Workflow context, but you can modify as needed):

Component Description	Combo box	Combo Box's Parameter	Parameter's Member Filter (Member List Type)
Entity Selection	cbx_Select_Entity	Select_Entity_WF	E#Root.WFProfileEntities
U2 Selection ("Department")	cbx_Select_Department	Select_Department_WF	U2#YourTopOfDepartmentName.DescendantsInclusive.Where(Text1 Contains |!Select_Entity_WF!|)

The key to making this work is two fold:

1. You add tags to the U2 dimension members in the Text1 field using the entity names.  Use a comma separated list for multiple entities on the same member
2. The Member Filter on the U2 Selection (Department) which has logic to filter the list to display only those members which are associated to the entity selected.

Make sure the first selection refreshes the dashboard component that contains the U2 Selection else the list won't show the relevant items.  Hope the above makes sense and happy to field follow-ups.

Cheers,

-DB