Re: Cognos questions

] Hi Folks, ] ] Some of you must be using Cognos reposrt writer. I would like to know ] how ] this works. Does it create views/superviews on the database? does it ] create ] temp tables on the DB ? Or rather does it write anything to the Informix ] database. I am evaluating this product and would like to know about Impromptu uses it's own layer outside the database known as an Impromptu catalog that allows you to present a business perspective to users creating their own reports. This layer has many features that provide for security and control to the catalog admins. When a report query is prepared Impromptu's internal SQL generation logic is pushed into our relational data service layer which communicates with an RDBMS via either a native interface, ODBC or other certified middleware. As much 'push-down' of the required querie(s) to the RDBMS is attempted as possible. -- Nigel Campbell Voice: (613) 738-1338 ext 3016 P.O. Box 9707,Stn.T Business Intelligence FAX: (613) 738-0002 3755 Riverside Dr. Cognos Incorporated Email: nigelc@cognos.com Ottawa ON K1G 4K9 http://www.cognos.com CANADA My comments are my personal opinion and are not the opinion of my employer or anyone else. I claim copyright in all my statements and give no one the right to copy them (even if they are quoted elsewhere) in any medium except on netnews or email. In particular, no one can reproduce or reprint my comments in print or any visual medium without getting my explicit permission.