Print Page - QUERY

Title: QUERY
Post by: sspk on 03 Mar 2008 03:22:23 PM

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 .

Title: Re: QUERY
Post by: aji136 on 03 Mar 2008 04:39:28 PM

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...

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sspk on 03 Mar 2008 03:22:23 PM