Gene, I support Cognos here. We create either materialized views for simple views and publish only those objects in the Cognos catalog. Anything else is madness. You cannot control the end users in the Cognos environment. They will do what they will. It's best to have a Cognos unit that works with the DBA's to publish what needs to be accessed. Good Luck! Tom -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of genegurevich@xxxxxxxxxxxxxxxxxxxxx Sent: Monday, May 01, 2006 9:21 AM To: oracle-l Subject: Cognos anyone? Hello , everyone: Does anyone out there have to support Cognos? We are in the process of migrating to it from microstrategy and I'm having a hard time dealing with the SQL it creates. They are huge. several pages long and absolutely undecipherable. I was wondering if anyone has any hints for working with that thing. thank you Gene Gurevich -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l