Dynamically controlling the contents of a filter in DeepSee II

[praven kumar]

Hi,
We are working on DeepSee II(2012.2 field test). We have two dropdown
filters in my dashboard, one for Facility and another for Physician.
When a user selects a facility, he should see in the Physician
dropdown only the physicians corresponding to that selected facility.
But we couldn't see any control for doing it, also we have tried
searching it in the documentation.

Kindly suggest.

Regards,
Praven

[Lexi Hayden]

Hi Praven,
We have a very new feature (I think not visible until the next field
test) that allows you to say that one level depends on another level,
for *exactly* the reason you want here.

In the level definition (only in Studio, I think), you include
something like
dependsOn="[otherdimension].[hierarchy].[level]"

This adds a combined index to the fact table that we use when we
retrieve members. The modeling guide in the field test will have
details and (for demonstration purposes) will show how to modify
SAMPLES to see this feature. It's pretty simple to do though.

So stay posted!
Cheers,
Lexi