If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos Reports w/o Framework Manager

Started by teelee, 06 May 2009 07:54:03 AM

Previous topic - Next topic

teelee

Hello All!
Does anyone know if there's a way to create reports in Cognos Report Studio without the data being published from Framework Manager? 

For instance, I have data on a server which is constantly changing, and I want to create reports against this data, but I don't want to model it in Framework Manager.  Is it possible to have Cognos point to the server just to create reports?

Thanks for any suggestions!  :)

blom0344

Yes, you should be able to bypass the model using straight SQL (directly or by conversion of Cognos SQL --> native/passthrough) However, you need to make sure that users are enabled to use reports that run directly with SQL

However, this is mostly used for testing , not for production. Managing reports this way is a chore!

teelee

Thanks blom0344,
How would I go about doing that? ???
Is it difficult?  I tried it, but apparently I don't know the process.

Thanks!

blom0344

Convert the SQL generated by Cognos.

In properties --> Query select the 'Generated SQL/MDX' property . In the GUI select the convert option (this is a one way proces!)
After the convert step you will see an additional icon for the converted SQL

Its properties are:

SQL syntax
Data source
SQL

However, when changing the SQL definition, you still need to make sure that you align the dataitems in the report with the returned object from the SQL..

teelee

Thanks blom0344,
I will try this or the DBA....

Have a wonderful day :)