RE: Reporting and Data Analysis Tools
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <Lee.Robertson@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Jul 2009 09:53:22 -0400
Lee,
The Oracle BI/Hyperion solution is "not bad". There is a meta data
layer that really can become a full time job maintaining if so allowed.
It can support pre-built reports that are generated based on time,
events, etc.. It also allows "power users" to build their own reports
and allows for "easy" access to the data by general users for adhoc
requests without their being SQL knowledgeable. Warning, this last part
can get out of hand pretty quick so I recommend reasonable profiles
inside the database.
A second product that comes to mind is Business Objects, also owned
by Oracle. It's very versatile, but you need a developer to set the
reports up. After that it's just a matter of the end user subscribing
to the report or scheduling it.
I believe both products can present reports as either e-mail or web
based retrieval.
Dick Goulet
Senior Oracle DBA
PAREXEL International
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Robertson Lee -
lerobe
Sent: Wednesday, July 08, 2009 8:03 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Reporting and Data Analysis Tools
Hi,
We have a requirement to supply a customer with a Reporting and Data
Analysis Tool recommendation and I have absolutely no experience in this
field whatsoever....
Some examples put up for consideration were Crystal Enterprise Server,
Oracle BI/Hyperion, Alterian DDV but this list was obviously not
exhaustive. Has anyone gone through anything similar and can point me
to best practices, documentations, case studies, previous
implementations etc.
I could just go through each products glossies/white papers etc but I am
not sure that would be of any use initially as I wouldn't know which was
better than the others.
The Data Warehouse will be built on Oracle 10g on AIX and will have
Mart(s) generated from it for reporting purposes.
Sorry for the vagueness of the request but I really am a newcomer to
this sort of stuff.
Regards and TIA.
Lee
************************************************************************
***
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally
privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank You.
************************************************************************
****
Other related posts:
