I have a couple of opinions here on several of these products.
Discoverer is more of an Adhoc querying tool for one quick answers to
issues. For example say you gave a manager a report and one number seemed
to high for what they are accustom to seeing. They can quickly go into
Discoverer and produce an online report that can be drilled down right into
the line detail of the total. Of course with Discoverer the success/failure
of the acceptance on this software is dependent on the administrator.
Discoverer is always growing and new views are created on a continuous
basis. One nice feature of Discoverer is the fact that you can bring in
external data. Training an end user on Discoverer takes about 1 hour and if
the user already knows Excel the training is even better. One down fall I
have seen with Discoverer is that if you want to create a report similar to
one that is all ready produce you have to start from scratch. Discover also
reports across the various modules in Oracle Financials. This system will
give you real time data.
Cognos I do not like for one main reason; They are a closed environment and
will not read other files into their "cubes". In my book that is not
acceptable.
Oracle Financial Analyzer is a tool that is similar to Discoverer but was
designed for the Financial Analyst out there and to do many projection. It
has as standard functionality more of the statistical calculation. If you
want these calculation in Discoverer you will have to create the function
and register it in Discoverer. There are more slicing and dicing that can
occur in OFA and the success of this tool is also dependent on the
administrator. OFA is built on a "cube" environment and if I remember
correctly is not real time and needs a job to update the data on a daily
basis.
-----Original Message-----
Sent: Thursday, May 10, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L
Hi Dick:
I have a similar project on my plate. I like Business Objects. Actually,
we do not want users to have to know table/column names and need a product
where we can build a data
repository. I am not sure if we need a complete end-to-end solution as many
BI companies seem ready to provide. Other vendors on our short list are -
Oracle (Discoverer), Cognos,
Brio, Informatica (not sure if we need it) and Sagent (has a nice ETL
product).
Mary Ruiz /Atlanta
-----Original Message-----
Sent: Thursday, May 10, 2001 2:11 PM
To: Multiple recipients of list ORACLE-L
To ALL,
I've been given a project to find a way to make data easily available to
end
users, preferably via a thin client (read that as browser based). We're
looking
at Discoverer 3000 and 9iAS, but the boss wants to know what other options
are
out there. The general idea would be to have a client/server based tool
that we
could deploy to the power users (of which we have only a few). These
individuals are NOT programmers nor in the IS group, but they know the data.
We
want them to create the queries/reports (with graphics included which the
Discoverer viewer does not do) and then publish them via the database. This
is
a lot of what Discoverer does, but are there other tools out there that do
the
same? Any recommendations???
Dick Goulet
Senior Oracle DBA
Vicor Corporation
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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: Ruiz, Mary A (CAP, CDI)
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: Dawn White
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).
