Skip to Content
0
Former Member
Aug 11, 2016 at 08:24 AM

Dynamic Query Drill

30 Views

Hello Experts

I have setup drill level as

LEVEL1 - Country

LEVEL2 - State

LEVEL3 - City

User wants the prompt at state level and also as their business is highly concentrated on US, they need US states in level 2 prompt.

Using SQL i acheived the same. So my prompts looks like follows

Select states -> All US states, Texas, california, florida, Hawai etc

The issue comes with drill

When user selects ALL us states, the user wants the drill to start with level 1 (ie country), where as when user selects any states then drill level should start with level 2 (ie state)

Let us know is it possible in Webi 4.1 sp5 ?

Thanks

Ben