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! :)
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!
Thanks blom0344,
How would I go about doing that? ???
Is it difficult? I tried it, but apparently I don't know the process.
Thanks!
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..
Thanks blom0344,
I will try this or the DBA....
Have a wonderful day :)