Display Drill Dimension List Dynamically

Hello All,

Is it possible to change dimension member list based on selection of a higher-level dimension in Web Intelligence document while it is in u201CDrillu201D mode?

It is very similar to cascading prompts behavior, but implemented for drillable dimensions. For example your choice of a US State dimension member would affect a US Cities dimension members displayed only for the selected State in its drop-down combo-box list.

Conditions: Webi documentu2019s data must be refreshed only ONCE and no linked BO documents are used.

Any ideas?

Kind Regards,

TZ