RE: Microsoft Excel vs. Oracle discoverer
- From: "Murching, Bob" <bob_murching@xxxxxxxxx>
- To: "'juancarlosreyesp@xxxxxxxxx'" <juancarlosreyesp@xxxxxxxxx>, "'oracle-l'" <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 12 Jul 2005 09:50:56 -0400
Discoverer lets you aggregate and report (dynamically) on a much larger set
of data than Excel typically is comfortable with. Therefore I treat
Discoverer as a tool by which a user can identify or create the subset of
information that he or she is interested in. Once they have sliced and
diced to get the "chunk" of knowledge they are looking for, I certainly
agree with you that Excel is the better tool for dressing it up for
presentation purposes.
We've also seen Discoverer act a hybrid query/research tool that can cut
down on development time. We have "quality control" users who are trying to
find a single errant record in a 10 million record table and we typically
built query forms for them. We have "analyst" users who want to drill
through 25% of that same 10 million record table and we typically built a
separate Oracle Reports-type report for them. With Discoverer, we can
expose the table in a manner that fits the needs of both users---at the same
time. You just have to be very careful thinking through the risks involved
with exposing a particular set of data via Discoverer instead of query forms
and canned reports.
-----Original Message-----
From: Juan Carlos Reyes Pacheco [mailto:juancarlosreyesp@xxxxxxxxx]
Sent: Tuesday, July 12, 2005 9:09 AM
To: oracle-l
Subject: Microsoft Excel vs. Oracle discoverer
Something funny I recently knew, is about a business who was trying to get
oracle discoverer to fit his needs several months, and finally discovered
that moving the data from oracle to an excel's spreadsheet, they could do
everything they want to do (several complex graphics and tables).
I don't know which is the sense of oracle dicoverer if you can use excel.
Specially for non technical people.
--
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i
8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: