Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Cognos
I worked as part of a "best practices" group once that used Oracle as the DBMS, Brio for the metadata and Cognos for the data mining/analysis. My impression was that Cognos worked great with highly trained users who had a great deal of business knowledge in a particular area. It is not an ad-hoc query tool for the masses.
As to the specifics ... that will depend on the quality of the people that you have administering the Cognos. How good are they at getting the users' true requirements and building them into data cubes? If the users really know what they want then Cognos can deliver. If the users can't define their needs then Cognos will be a nightmare.
Like all powerful tools, it requires a great deal of planning in order to be used effectively.
"Vergara, Michael To: Multiple recipients of list ORACLE-L (TEM)" <ORACLE-L_at_fatcity.com> <mvergara cc: @guidant.com> Subject: RE: Cognos Sent by: root 07/18/2002 01:28 PM Please respond to ORACLE-L
Our Data Warehouse group uses Cognos PowerPlay to build cubes for the end users, and Cognos Impromptu for on-line drill-down and reporting.
IMHO, Cognos writes crappy SQL. The users say they cannot insert hints, so you have to be ready for almost any kind of query.
It's got a nice GUI, though, they tell me.
Cheers,
Mike
-----Original Message-----
Sent: Thursday, July 18, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L
Anybody have any experience with "Cognos"? We've got a bhb that thinks its
the solution for giving every end user access to the raw data
(groan...loudly!)... I've argued every which-a-way against the concept,
now
I have to fight the specifics....
HELP!
John P Weatherman
Database Administrator
Replacements Ltd.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: john.weatherman_at_replacements.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Jul 18 2002 - 14:49:14 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: mvergara_at_guidant.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: tday6_at_csc.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |