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.
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).
The key feature of this forecasting application is the reusability of objects created during the development process. The sample includes the following files:
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:
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. |
forecast.jsp
-- Runs the forecasting HTML-client sample to demonstrate
the advanced forecasting capabilities of Oracle9i OLAP within a JSP
(HTML-client) application.
ForecastExecutor.java
-- Executes the required forecast and adds
the resulting measure to the query. The following methods are relevant:
addForecastMeasures
-- Adds the forecast measure(s) to the
presentation query and executes a program to generate the forecast data.
removeForecastMeasures
-- Removes the forecast measure(s)
from the presentation query.
executeForecast
-- Executes the specified forecast method
to generate the required data.
The following kinds of forecasting are available:
Linear
Non_Linear
Trend
Exponential
Seasonal
Best Fit
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.
![]() |
|
---|---|
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. |