Oracle Discoverer is a business
intelligence tool to support organizational decisions. It uses
a repository called EUL (End User Layer) which is based on information
stored and controlled by transactional applications. The main EUL
goal is to hide details and complexity of a transactional database,
organizing data to reflect the company specific business areas,
making all data queries faster and easier.
Oracle E-Business Suite (EBS - also known as Oracle Applications
and sometimes called Oracle Financials) has a BI module with an
EUL mapped from Oracle EBS transactional data, which permits Oracle
Discoverer to be used as a decision
support tool for information stored into Oracle EBS database.
By using Oracle EBS security schema, which uses responsibilities
to control access rights, Oracle Discoverer shows its repository
in a user friendly way, using folders for each business area, listing
all items that you can select for a query. When you select an item
for a query, all items that don’t have relationship with this first
selected item will be disabled for selecting because every relationship
and dependencies are mapped
through EUL.
All Oracle Discoverer queries can be viewed in a tabular or matrix
formats, allowing the definition of data fields (items) at the header
of a report. This is used to filter the result set of data to be
shown. There are many data format functions and it is possible to
change
the reports layouts, allowing conditional format of characters
fonts and colors for each column of data. Besides this features,
you can change columns positions, order and group data dynamically.
Oracle Discoverer can be executed by a local desktop software installation
(Oracle Discoverer Desktop Edition) or using a browser via web (Oracle
Discoverer Plus). Additionally you can export the reports for Html
files, Microsoft Excel and other file formats.
All of these characteristics make Oracle Discoverer a powerful and
useful tool for Oracle E-Business Suite reporting, beyond Oracle
Reports and XML Publisher, each one with its features and benefits.
If your company has specific business requirements that are not
totally satisfied by Oracle EBS reports, please give us a call and
we will deliver you the best customized solutions using any of these
reporting tools.
About Alba Spectrum Technologies. Alba Spectrum Technologies is
joint venture of several IT and business consulting companies, now
operating as single business entity. We have local presence in the
Houston, Chicago, New York, Los Angeles, San Diego, Dallas, Miami,
Atlanta, Denver, Phoenix, New Orleans, Minneapolis, San Francisco,
LATAM & Brazil, Germany, Russia, South East Asia and Oceania. We
believe in the coexistence of Java (J2EE, EJB, Linux, Unix), Oracle
and Microsoft (.Net, C#, VB) platforms and systems and specialize
in several product lines and cross platform integration, customization,
heterogeneous report design, plus we provide ERP/CRM systems comparison
and reviews, not being committed to just on MRP platform. We also
stake on XML cross-platform data interchange to be advanced in the
coming decade.
Alba Spectrum Technologies websites:
http://www.albaspectrum.com
http://www.greatplains.com.mx
http://www.enterlogix.com.br
http://www.ronix-systems.de
2009
