I am using Cognos with a postgreSQL database.
I am using an "ODBC"-type data source connection.
When I try to run a report in Report Studio, I get the error: "Derived tables are not supported by the database." My understanding of this error is that Cognos wants to use a sub-query (which is perfectly acceptable in postgreSQL).
Why does Cognos think that it can't use derived tables? Just because of the ODBC connection?
Where are the options to set what is (or is not) supported in the database? How can I over-ride Cognos' default?
I know that I can enable "limited local" processing and this will work, but I can NOT resort that this option - the processing needs to happen in the database.
Thank you,
-John
what you could try (at your own risk) go to your installation directory/bin directory.
Edit the file COGDMOD.ini
Look for the line
[Exceptions Tables]
; Entries added here affect all ODBC connections.
; For this reason overwrites should be added to subsections only.
; The entries below show the ODBC defaults.
Derived=F
Joined=F
Simple=T
and change Derived = F to Derived=T
This might work (maybe restart your server)
Let me know if it worked
ReportNet Addict,
Yes, that does work (and after Derived I had to then tell Cognos that Distinct was OK to use also).
Thanks very much for the help.
-John
You're welcome... And don't forget to note your changes because as with each update this file could be overwritten!
Great info RA - many thanks! :)
You're welcome..