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)" <[EMAIL PROTECTED]>
<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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Vergara, Michael (TEM)
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
