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

Derived tables are not supported by the database.

Started by disco29, 05 Jan 2011 06:02:42 PM

Previous topic - Next topic

disco29

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

sir_jeroen

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

disco29

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

sir_jeroen

You're welcome... And don't forget to note your changes because as with each update this file could be overwritten!

MFGF

Meep!

sir_jeroen