The focus
of these OBE lessons is to create analytic reports using OracleBI Beans. We
will assume that the first step in implementing a BI 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 first Focus Area, Creating Business Intelligence Objects, is to create
the primary objects that enable OLAP analysis -- Calculations, Crosstabs,
Graphs, and Saved Selections.
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
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.
-
Senior executives want an
aggregated view of the business data, one that allows them to drill down through
layers of OLAP data.
-
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 the BI Beans Calculation wizard.
·
The selection for Geography
will be the same throughout the workbook. The geographies of interest are
Worldwide, Americas, Asia, Europe, and Oceania. Africa and the Middle East
are new markets for which there is no data so you should omit those regions
from all reports.
·
The focus is on profitability
in 2001. Therefore, you should base most queries on time periods in 2001.