BI Beans Samples Overview

Oracle Corporation provides tutorials and samples to help you learn how to develop business intelligence applications using BI Beans. Tutorials walk you through the entire development process, step by step, while samples explore a particular functional area in greater detail or demonstrate more complex coding situations.

Samples must be downloaded from Oracle Technology Network (http://otn.oracle.com). You should check Oracle Technology Network often to obtain the latest samples.

Before you begin

If you have not already done so, then you must must perform several installation and configuration tasks before you can begin to work with the samples. For instructions, see Installing and Configuring the Samples.

Descriptions of the samples

Sample Scripts for managing the BI Beans Catalog

Sample Scripts Description

Using the Local and Remote BI Beans Catalog

Demonstrates the best practice for using the BI Beans Catalog with the tools provided within JDeveloper and BI Beans

BI User Community Synchronization with LDAP

Demonstrates how the BI Beans Catalog can be synchronized with external user communities such as LDAP

BI User Community Synchronization with RDBMS

Demonstrates how the BI Beans Catalog can be synchronized with external user communities such as a relational database

Samples for Java-client applications

Sample Description

Connecting to Oracle9i OLAP and BI Beans Catalog

The "Hello World" for BI Beans Java-client applications. Demonstrates how a BI application connects to Oracle9i OLAP (the source of the business data for the application) and to the BI Beans Catalog (where object definitions, such as crosstabs and graphs, are saved). This sample is extended by the other Java-client samples.

Using QueryBuilder Capabilities

Demonstrates how QueryBuilder functionality can be used in different contexts. This sample explores the QueryBuilder methods that enable simplified access to QueryBuilder functionality.

Using Rules to Format Crosstabs

Explores the use of rules to specify custom formatting for a crosstab. This sample introduces different types of formatting, including the cell level formatting, currency format, header formats and data-driven stoplight format

OLAP Dimension List Panel

Demonstrates how to use the Dimension List bean components to alter the dimension values used in a query and how to apply the query to a presentation.

Creating Calculations

Shows how to use the CalcBuilder to define a new calculation and insert it into a crosstab. Also shows how to insert a predefined calculation type into a crosstab using popup menus.

Linking Presentations

Demonstrates how to link queries and selections between views (for example,  crosstab, table and graph).

Creating and Formatting Graphs

Demonstrates how to generate a graph using the QueryBuilder and Graph format panels.

New Presentation Wizard

Demonstrates how to create a custom wizard for end users to define new, data-aware crosstabs and graphs.

Printing Crosstabs

Shows how an application can incorporate the BI Beans Print, Page Setup, and Preview dialogs to print crosstabs.

Applying BI Beans Catalog Features

Introduces a number of BI Beans Catalog features in an application, including the following:

  • Creating directories and providing user access to them

  • Using the Explorer to navigate the catalog

  • Opening components that have been saved in the catalog

  • Displaying the XML definitions of a saved BI Beans object

Importing and Exporting Objects

Shows how to create two BI Beans Catalog connections and how to copy objects among multiple catalogs.

Retrieving Metadata from Oracle9i OLAP and the BI Beans Catalog

Demonstrates how a BI Beans application can retrieve metadata from a metadataManager that is connected to Oracle9i OLAP (the source of the business data for the application) and to the BI Beans Catalog (where object definitions, like crosstabs and graphs, are saved).

Forecasting using Orace9i OLAP

Demonstrates how BI Beans can take advantage of Oracle9i OLAP to add forecasting capabilities to an application

Samples for HTML-client applications (servlets and JSPs)

Sample Description

Connecting to Oracle9i OLAP and BI Beans Catalog

The "Hello World" for BI Beans servlet applications. Demonstrates how a BI application connects to Oracle9i OLAP (the source of the business data for the application) and to the BI Beans Catalog (where object definitions, such as crosstabs and graphs, are saved). This sample is extended by other servlet samples.

Linked Views

Shows how to link a crosstab and graph. Selection changes made to one presentation are reflected in the other. Uses the FindMember tool to enable navigation of large lists of dimension members that are displayed in the page controls.

QueryTool - Creating a Custom ViewTool

Demonstrates how to create a custom query tool that allows users to specify query conditions such as "Select Cities where Sales are in top 10."

State Handling

Demonstrates how to manage state for a BI Beans application, including support for the browser's Back button and for bookmark navigation.

View Toolbar

Shows how to use the BI Beans ViewToolbar to modify a data presentation. Displays the events that are fired when users interact with the application.

Multiple Page Application

Illustrates navigation among multiple pages in a BI Beans application, in this case, between two pages. The first page allows users to navigate the BI Beans Catalog directories and select a saved report. The second page opens the report so the user can analyze the data.

JSP Application Using Frames

Demonstrates how a BI Beans JSP application can be developed in a multi-frame environment. Uses the BI Beans JSP tags to build the application.

Forecasting using Orace9i OLAP

Demonstrates how BI Beans can take advantage of Oracle9i OLAP to add forecasting capabilities to an application

BI Beans within Struts

Demonstrates how to create a BI Beans application within the Struts framework

Displaying BI Reports in Oracle Application Server Portal

Demonstrates how to create an integrated BI Beans and Portal application.