The focus
of these OBE lessons is to create analytic reports using Oracle BI Beans.
We will assume that the first step in implementing a business intelligence
system is for analysts to create the BI Beans objects that can be used in
reports. Then, a JSP or Java Client application is developed that uses the
BI Beans objects. Users perform their analysis by using the BI Beans applications.
Your goal
in this second focus area, Creating BI Beans Applications, is to use the BI
Beans objects that were created in the first focus area in JSP and Java Client
applications.
The requirements
for the Business Intelligence system are listed below. These requirements
have been used to develop a data design.
-
The initial implementation
of the Business Intelligence system must provide insight into the company's
sales, costs, and profits.
- The data structures must enable summary (or aggregated) levels of OLAP data as well as the ability to drill to lower levels of OLAP data.
-
One important requirement
is to be able to achieve time-based analysis, including the analysis of product
performance across time periods.
-
Reports must have an intuitive
graphical user interface.
-
Users must be able to conduct
different levels of analysis over the web.
Assumptions
·
The measures available for
this project are in the Electronics -KPIs measure folder. They are Sales Revenue,
Sales Cost, and Quantity. If you need
to create calculations to meet reporting requirements, they must be created
using BI Beans Calculation wizard.
·
The selection for Geography
will be same throughout these lessons. The geographies of primary interest
are Worldwide, Americas, and Europe. Africa and the Middle East are new markets
for which there is no data so you should omit those regions from all reports.