QUERY

[sspk]

HI All,
I have a report with prompts on that, i want to see the  sql that the report is doing for particular prompt values.How to see the sql .

[aji136]

Hi,

I know of 2 ways of doing this:
1. Select the Query (that is using the prompt) -> Go to the Properties and under Data section, select ... for Generated sql/mdx
2. Select the Query -> Go to Tools -> Click Show Generated SQL/MDX

I hope this is what you are looking for...