Query prompt selectors Dependency

Hello everyone,

I am using dashboard designer query browser ( BICS and JCO connection ) and Query prompt selectors ( As filters) . 1. Region 2. Territory 3. Town

Now i want if i:

Select A region, Territory search list should show only those territories which are under Selected Region and Town list should show

according to selected territory.

Right now i am getting all LOV.

Thanks in advance..............

Vaishali Wadhwa.