RE: Microsoft Excel vs. Oracle discoverer

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_at_gmail.com] 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
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jul 12 2005 - 08:53:02 CDT