| Oracle Applications, Oracle E-Business Suite, Oracle | | | | don't have relationship with this first selected item will |
| Financials, Oracle Reports, Oracle Discoverer | | | | be disabled for selecting because every relationship |
| Oracle Discoverer is a business intelligence tool to | | | | and dependencies are mapped through EUL. |
| support organizational decisions. It uses a repository | | | | All Oracle Discoverer queries can be viewed in a |
| called EUL (End User Layer) which is based on | | | | tabular or matrix formats, allowing the definition of data |
| information stored and controlled by transactional | | | | fields (items) at the header of a report. This is used to |
| applications. The main EUL goal is to hide details and | | | | filter the result set of data to be shown. There are |
| complexity of a transactional database, organizing data | | | | many data format functions and it is possible to |
| to reflect the company specific business areas, making | | | | change the reports layouts, allowing conditional format |
| all data queries faster and easier. | | | | of characters fonts and colors for each column of |
| Oracle E-Business Suite (EBS - also known as Oracle | | | | data. Besides this features, you can change columns |
| Applications and sometimes called Oracle Financials) | | | | positions, order and group data dynamically. |
| has a BI module with an EUL mapped from Oracle | | | | Oracle Discoverer can be executed by a local |
| EBS transactional data, which permits Oracle | | | | desktop software installation (Oracle Discoverer |
| Discoverer to be used as a decision support tool for | | | | Desktop Edition) or using a browser via web (Oracle |
| information stored into Oracle EBS database. | | | | Discoverer Plus). Additionally you can export the |
| By using Oracle EBS security schema, which uses | | | | reports for Html files, Microsof Excel and other file |
| responsibilities to control access rights, Oracle | | | | formats. |
| Discoverer shows its repository in a user friendly way, | | | | All of these characteristics make Oracle Discoverer a |
| using folders for each business area, listing all items | | | | powerful and useful tool for Oracle E-Business Suite |
| that you can select for a query. | | | | reporting, beyond Oracle Reports and XML Publisher, |
| When you select an item for a query, all items that | | | | each one with its features and benefits. |