Skip to Content
0
Former Member
May 27, 2010 at 03:31 PM

SQL Generated in WEBI

148 Views

Hi,

Have an interesting question.

Lets say my report has a prompt on Zone - This is my prompt syntax.

TableA.ZONE IN @Prompt('Enter Zone or type All', 'A', '(ClassA\Zone)', MULTI ,FREE)

Now my SQL in WEBI would be showing this prompt syntax in WHERE condition.

But what would happen once I choose a Zone at runtime, or once I enter All, where can I see the new sql that hits the database. I feel this should definitely be stored in some place - the sql with the prompt answer.

Can anyone think of an answer to this question - I will really appreciate it if you can give me any leads.

Thanks All!!