Oracle Business Intelligence Beans Sample

Executive Insight

Overview

Executive Insight application is designed to be a showcase for Oracle Business Intelligence Beans technology. It demonstates many of the key features that make BI Beans a unique development environment and show why BI Beans was voted Best Visual Bean/Component 2003 by JavaPro readers.

This Executive Insight application consists of a briefing book containing the following pages:

The application is designed around a dashboard style executive sales analysis briefing and uses many powerful key OLAP features that are part of Oracle OLAP. The schema for the application was built using Oracle Warehouse Builder.

The following section describes the features that are demonstrated on each page of the application:

Sample

Description

Home Page

This is Executive Insight home page and hence the starting point for the briefing. The home page is designed to provide a high level overview of the key business drivers, allowing a user to drill down to more detailed analysis on subsequent pages.

Product Insight

TheProduct Insight page is designed to have a dashboard look and feel. This page is divided into three main regions:

  • Query Buttons that provide quick access to each product division
  • Summary briefings providing analysis of Revenue, Costs and Margin
  • Briefing navigation buttons

The aim of this page is to provide a detailed snapshot of the key business performance indicators in relation to product as a business driver.

Customer Insight

The Customer Insight page is simlar to the Product Insight page. It is divided into three main regions:

  • Query Buttons that provide quick access to each product division
  • Summary briefings providing analysis of Revenue, Costs and Margin
  • Briefing navigation buttons

The aim of this page is to provide a detailed snapshot of the key business performance indicators in relation to geography as a business driver.

Sales Analysis

The Sales Growth and Margin Analysis page has a slightly different look and feel to the other pages we have reviewed so far.

The buttons on the left hand side have been replaced with a Product selection lists that allows the user fined grained control over the data points visible in the main graph.

The aim of this page is to provide a detailed analysis of current and potential future sales revenue for individual products. Previous pages have concentrated on high level Product Division and Geographical Region analysis. Using this page it is possible to drill down into the detailed information.

The Line graph is able to display some of the many advanced analytic functions present within Oracle OLAP. Here the graph is used to display 6 and 12 month moving averages as well as revenue projections based on the Oracle OLAP forecasting engine.

What If Analysis

The layout of the What If Analysis page follows the same approach as the Product Insight and and the Customer Insight pages.

The page is divided into three main regions

  • Query Buttons that provide quick access to each product division
  • Campaign Options that provide the inputs to the model
  • Briefing navigation buttons

This page allows the user to execute OLAP DML to model future sales revenue, costs and margin based on running different marketing promotions.

Adhoc Analysis

The Adhoc Analysis Page demonstrates a number of key components of this new release of BI Beans. The presentation is linked to the new thin HTML Query Wizard and Calculation Wizard.

Before you begin

Before you can run the BI Beans Executive Insight sample, you must perform the following installation and configuration tasks:

Install the demo database schema

If you have not already done so, then you must install the Oracle OLAP Common Schema Analytic Workspace. This data set is used by the BI Beans samples and tutorials, as well as other tools such as Oracle OLAP Spreadsheet Add-in and OracleAS Discoverer.

Install and configure the BI Beans Catalog

If you have not already done so, then you must install and configure the BI Beans Catalog, which allows end users to save and share analyses.

Update the samples project settings

In JDeveloper, settings in the BI Designer determine how the samples connect to Oracle OLAP and to the BI Beans Catalog. To enable the samples to connect correctly, you must update the settings in the catalog project that you download with the samples. Updating this one project ensures correct connection information for the sample

1. In JDeveloper, expand the bibeans workspace, the executiveInsight project, and the Application Sources node of the project.

2. Right-click executiveInsightBIDesigner1 and select Settings from the popup menu.

3. Specify the Oracle OLAP data source connection:

4. Choose OK to close the BI Beans project settings.

5. From the File menu, choose Save All.

6. Right-click the executiveInsight project and select Rebuild from the popup menu.

You are now ready to begin using the Executive Insight demo.

Running the Executive Insight sample

In JDeveloper, expand the bibeans workspace and expand the executiveInsight project. Within the Web Content folder, select the BIHome.jsp, right-click and select Run from the popup menu.


Copyright © 2004 Oracle Corporation.
All Rights Reserved.