# 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:

- Home Page
- Product Insight
- Customer Insight
- Sales Analysis
- What If Analysis
- Adhoc Query and Analysis

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:

- Choose Edit under the Data Source connection field.
- On the Authentication tab, change the ID and password, if necessary. You must perform this step if you changed the ID and password when you installed the CS_OLAP schema.
- On the Connection tab, change the Hostname, Port, and SID appropriately.
- On the Test tab, select Test Connection to test your connection.
- If the connection test succeeds, then choose OK to save the Oracle OLAP connection information.

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.