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:
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:
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
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 can run the BI Beans Executive Insight sample, you must perform the following installation and configuration tasks:
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.
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.
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.
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. |