Oracle Business Intelligence Discoverer is an intuitive ad-hoc query, reporting, analysis, and Web publishing tool that gives users immediate access to crucial data in the databases.
Oracle Business Intelligence Discoverer enables business users from all the levels of the organization to make quicker and more informed business decisions. Using any standard Web browser, you have secure and immediate access to data both from relational and multidimensional data sources. Oracle Business Intelligence Discoverer provides a User friendly view to hide the complexity of the underlying data structures, which enables you to focus on solving major business problems.
Oracle Business Intelligence Discoverer comprises of numerous integrated components that work together with the Oracle database to give the user a complete and integrated Business Intelligence solution.
Topics to be covered in
this article.
Why Oracle BI Discoverer
What are Workbooks
What are Worksheets
What is a cube? Components of a cube.
What is EUL(End User Layout)?
How to edit a Discoverer Connection?
Why Oracle BI Discoverer
Decision makers today need a business intelligence solution to track up to date company information and KPIs. Part of Oracle Business Intelligence,
Using Discoverer Viewer, business users can easily turn you data into valuable information and publish it seamlessly throughout the enterprise using a familiar and intuitive UI, the Web browser.
Reasons why you use
Discoverer Viewer are as follows:
- Safe-to-use Interface
- Consistency with Discoverer Plus and Discoverer Desktop
- Database Security
- Integration and Customization
- Easy-to-use Interface:
Discoverer Viewer is an easy to use Interface and allows you to interact directly with your business data using familiar terminology and a Web browser. Anyone familiar with using a browser will quickly be able to use Discoverer Viewer.
Consistency with Discoverer Plus and Discoverer Desktop
Existing business views of the database are immediately available to Discoverer Viewer users. Any reports (workbooks) created using Discoverer Plus or Discoverer Desktop can be run from Discoverer Viewer immediately
Familiar Browser Facilities with Discoverer Viewer
All the usual facilities of your Web browser are available:
- Bookmark your favorite reports
- Use the Back and Forward buttons to navigate
- Use the browser Print function for print output
- Launch registered applications to process data exported using Discoverer Viewer
Database Security
Discoverer Viewer uses the existing database security as defined within Discoverer Administrator. There is no need for any additional setup, and no one can view data without authorization. When used with Oracle Applications, Discoverer Viewer uses the Oracle Applications security model, including the use of roles and responsibilities.
Integration and Customization
Discoverer Viewer can be used as a standalone business intelligence tool or can be used to integrate database output into your Web site and portal. In addition, Discoverer Viewer is easily customized to fit in with your Website look and feel, to incorporate your company’s logo or other artwork, or to build custom Discoverer applications for the Web.
What are Workbooks
Workbooks are Discoverer files that contain worksheets displaying data retrieved from the database. If you are familiar with spreadsheet applications (e.g. Microsoft Excel), imagine workbook as a spreadsheet file. Discoverer workbooks are stored in the database (for relational data) or the Discoverer Catalog (for multidimensional data).
What are Worksheets
Worksheets contains the data that you want to analyze, along with a number of Discoverer components to help you analyze business data. For example, a worksheet can contain parameters, totals, percentages, exceptions, and calculations. If you are familiar with spreadsheet applications (e.g. Microsoft Excel), imagine workbook as a spreadsheet file and worksheets as different sheets in that spreadsheet file.
What is a cube? Components of a cube.
A cube in a multidimensional data source has the following components:
- A measure, which is the name given to the data itself.
- One or more dimensions. Dimension is the name given to the parts of the cube that categorize the data, such as Product, Time and Geography. Dimensions have dimension members, dimension hierarchies, and attributes.
The cube contains a measure value for each possible combination of the different dimensions. It is therefore very quick for applications such as Discoverer Plus OLAP to find the value for sales of a particular product in a particular city in a particular year.
What is EUL(End User Layout)?
The EUL is an intuitive, business-focused view of the a relational database that uses terms that are user friendly with and can easily understand. The EUL eases the user from the complexity usually associated with databases. This enables you to focus on business issues instead of data access issues. The Discoverer manager creates the EUL so that you see a user-friendly view of the database when you use Discoverer.
If you start Discoverer using a public connection, the Discoverer manager specifies an EUL for you. If you create your own connection, you select the EUL yourself, or you can use the default EUL assigned to you
How to edit a Discoverer Connection?
You edit a Discoverer connection when you have to change the login details stored in that connection. For example, you might want to change the username that you use to start Discoverer Viewer.
To edit a Discoverer
connection:
Display the Discoverer Viewer connections page
Select the pencil icon in the Update column next to the name of the connection that you want to edit.
Change the connection details as required.
Save the details by doing one of the following:Click Apply to save the details you have entered and return to the Connections list.
Click Apply and Connect to save the details you have entered and start Discoverer Viewer using the login details you specified.
If the username has access to more than one End User Layer, the Create Connection:
End User Layer page is
displayed. Do the following:Select an End User Layer from the End User Layer drop down list.
- Click Apply to save the details that you specified.
- Click Apply to save the details that you specified.
If you clicked Apply, the
Connect to OracleBI Discoverer Viewer page is displayed. The new connection
that you have created is included in the list of connections. To start
Discoverer Viewer using the connection that you have created, click the new
connection name in the Connection list.
If you clicked Apply and
Connect, Discoverer Viewer starts and prompts you to select a workbook and
worksheet to open.