Oracle Business Intelligence Beans Sample

Forecasting using Oracle9i OLAP

Overview

This sample is designed to help you learn how to develop business intelligence applications using BI Beans. In conjunction with the related Oracle Magazine Article (March/April 2003 -- at http://otn.oracle.com/oramag/oracle/03-mar/o23business.html). It walks walk you through the entire development process, step by step, exploring key functional areas in greater detail and demonstrating key coding situations.

Setup Requirements

Install the awdemo sample schema by referring to the readme file (i.e., forecast\awdemo_readme.txt).

Open the workspace forecast\forecast.jws under the samples directory in JDeveloper. All the necessary files for this sample can be found in the forecast.jpr project under the forecast.jws workspace.

Modify the BIDesigner design settings in the project to the BI Beans environment where you have installed the awdemo schema (similar to "Update the sample project settings" under Installing and Configuring the Samples).

Code Highlights

The key feature of this forecasting application is the reusability of objects created during the development process. The sample includes the following files:

For the Java-Client Environment

File name Description
BIFrame

The main class for the BIFrame sample. Also serves as the base class for all the other Java-client samples.

The BIFrame is essentially a JFrame that provides a menu with access to a simple connection dialog. The dialog prompts a user for connection information that is used to connect to Oracle OLAP and the BI Beans catalog

The following can be further customized by subclasses:

  • Menu bar for the frame

  • Tool bar for the frame

  • Status bar for the frame

  • Main display panel for displaying the view

  • Name of the BI Configuration file

The subclasses also have access to the BISession instance and the MetadataManager instance.

BIForecasting.java Runs the forecasting Java-client sample to demonstrate the advanced forecasting capabilities of Oracle9i OLAP from within a Java-client application.

For the HTML-Client (JSP) Environment

forecast.jsp -- Runs the forecasting HTML-client sample to demonstrate the advanced forecasting capabilities of Oracle9i OLAP within a JSP (HTML-client) application.

Shared Application Logic

ForecastExecutor.java -- Executes the required forecast and adds the resulting measure to the query. The following methods are relevant:

The following kinds of forecasting are available:

How To Run

To run the Java-client forecasting sample within JDeveloper, right-click BIForecasting.java and choose Run BIForecasting.java.

To run the HTML-client forecasting sample within JDeveloper, right-click Forecast.jsp and choose Run Forecast.jsp.

oracle logo  
Copyright © 2003 Oracle. All Rights Reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.