The focus
of these OBE lessons is to create reports using Discoverer Plus OLAP. We will
assume that the first step in implementing a business intelligence system
is for analysts to create reports, which are then viewed by executive managers
using Discoverer Viewer.
Your goal
is to create a Discoverer Plus OLAP workbook that contains the profitability
reports that executive management can use to track key performance indicators
across geographies and sales channels.
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 Discoverer Plus OLAP.
·
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.