« previous next »
Pages: [1]

Author Topic: Analysis Studio : Generated SQL  (Read 619 times)

Offline tibo-k3

  • Full Member
  • ***
  • Posts: 8
  • Forum Citizenship: +0/-0
Analysis Studio : Generated SQL
« on: 23 Mar 2011 04: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 !
« Last Edit: 23 Mar 2011 05:01:38 am by tibo-k3 »
Logged

Offline NimrodA

  • Full Member
  • ***
  • Posts: 24
  • Forum Citizenship: +5/-0
Re: Analysis Studio : Generated SQL
« Reply #1 on: 23 Mar 2011 05: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)
Logged

Offline tibo-k3

  • Full Member
  • ***
  • Posts: 8
  • Forum Citizenship: +0/-0
Re: Analysis Studio : Generated SQL
« Reply #2 on: 24 Mar 2011 04:37:27 am »
Thank you, it's perfect... That was exactly what i needed !
Logged
Pages: [1]
« previous next »