| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Reporting tools
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: dgoulet_at_vicr.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).
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).
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). Received on Thu May 10 2001 - 13:50:27 CDT
 |
 |