Cognos Transformer Possibilties

[PM]

Hi Guys,

We are going to start some experiment now on Cognos Transformer in our company. Til now we are using report studio only.
I could connect the reports to tranformer, but is there any way to connect direct DB ( oracle) ?


Thanks,

[bdbits]

NO.

Well, you can write direct SQL in report studio, but it would disrupt the space-time continuum if you try to use it. So in the interest of self-preservation, I cannot share the secret. It is buried in the report studio user guide (RS help) if you insist on destroying the universe and all of us with it.

Seriously, do not go there. It negates the foundational reasons to use Cognos in the first place.

[PM]

So,  if I understood you correctly , so you are trying to say its only possible to connect with RS or Frame work ?

[bdbits]

You have to have a package to at least tie back to a datasource, but writing direct SQL will not use the package in any other way.

I'm not saying you cannot do it, I am saying you _should_ not do it. Using SQL directly in a report bypasses tons of functionality built-in to Cognos, makes it non-portable (e.g. even database version upgrades could break it), complicates efforts at Cognos performance optimization, and short of going into each and every report, makes reflecting changes from your database to existing reports next to impossible.

Just say no.

[cognostechie]

@ PM - What exactly has Transformer got to do with connecting reports to the DB ? What is in your mind that you are contemplating about?

Transformer is a tool which takes the data from the DB, hijacks it, converts the data into OLAP format and then puts the data inside the Cube. Once that is done, then Oracle loses all copyrights to the data as it becomes the property of Transformer. After this, the reports will go to the cube and
will not go to the DB at all because the data gets stored inside the cube. If you are talking about putting SQLs inside the report so that the reports
can shake hands with Oracle then that has nothing to do with Transformer.

What exactly is your question ?