Analysis Studio : Generated SQL

[tibo-k3]

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 !

[NimrodA]

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)

[tibo-k3]

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