Oracle-L: RE: Cognos

From: Jay Hostetter <jhostetter_at_decommunications.com>
Date: Fri, 19 Jul 2002 04:43:21 -0800
Message-ID: <F001.0049C774.20020719044321@fatcity.com>

We had a similiar experience here. I would say that only 10% of the users are really using PowerPlay to its full potential. It requires:

1) a person with analytical skills 
2) a person with a very good understanding of the data
3) a person that has time to "play" with the data.

Most of the other users bring up canned PowerPlay reports, and tweak a dimension or two. Very few of them build their own reports and drill deep down into the data. I still think it is a great tool. I setup an cube based on the concurrent requests in our Oracle Financial system. I can find bottlenecks in the concurrent managers, see who submits the most intensive reports, etc.

Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA

>>> dbrowett_at_city.coquitlam.bc.ca 07/18/02 05:11PM >>> We have deployed cognos, first a local install on all P.C.'s and we are now migrating to the Web based solution.

The original selling point was that everybody would be able to quickly and easily create their own reports, with the users accessing our production databases. How wrong that was.

What we have now is a central database (we call it a datawarehouse) that houses snapshots and custom reporting tables. All reports are basically canned, and we have a staff member who function is to maintain/build reports and the warehouse. At some point I am sure that users will be able to create their own reports, but from our datawarehouse, not production.

-----Original Message-----
Sent: 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-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: Browett, Darren
INET: dbrowett_at_city.coquitlam.bc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jay Hostetter
INET: jhostetter_at_decommunications.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------