Dynamic Query Drill

[Former Member]

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

[Former Member · Accepted solution]

There is a similar sort of requirement placed as an idea. So I believe you need to wait for this to be released.

https://ideas.sap.com/D29704

Regards

Niraj

[Former Member · Accepted solution]

Hi Niraj

Any workaround for this issue?

Ben