Print Page - Analysis Studio : Generated SQL

Title: Analysis Studio : Generated SQL
Post by: tibo-k3 on 23 Mar 2011 05:39:02 AM

Hi,

I just started to use Cognos BI 8.4 (so, sorry if my question is not relevent), notably Analysis Studio.

I connected COGNOS to an Oracle 11g database (so Cognos Connection use the Oracle Client 11g to connect the database). Alos, I'm using FrameWork Manager to generate my cubes.

I would like to know if there is any way to get the SQL Request generated by Analysis Studio ? (i.e. to obtain the string "SELECT column FROM ... etc...")

Thank you !

Title: Re: Analysis Studio : Generated SQL
Post by: NimrodA on 23 Mar 2011 06:10:19 AM

Firstly, Analysis Studio generates mdx, not SQL. Secondly, the only way I know to view the generated mdx is to open the analysis in report studio and pull it from there (Tools->Show generated sql/mdx)

Title: Re: Analysis Studio : Generated SQL
Post by: tibo-k3 on 24 Mar 2011 05:37:27 AM

Thank you, it's perfect... That was exactly what i needed !

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Analysis Studio => Topic started by: tibo-k3 on 23 Mar 2011 05:39:02 AM