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.

Descriptions of the Samples

Java-client samples

Sample Description

Ad-Hoc Analysis Tool

Allows users to create new presentations, customize them, and save them. It incorporates code from several other BI Beans Sample applications, integrating them into a single, complete application.

Using QueryBuilder

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

Formatting 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

Using Dimension List

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).

Modifying Graphs

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

Custom 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.

Using BI Beans Catalog

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

  • Creating directories and providing user access
  • 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

Exporting Objects

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

Browsing Metadata

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).

JSP samples

Sample Description

Executive Insight Dashboard Application

A complete interactive dashboard application that demonstrates the different analytic features of BI Beans

BI Beans JSP Tag Guide

A set of JSP pages that demonstrate the BI Beans JSP tag library: List tags, dialog and wizard tags, and general tags.

Data Writeback

Demonstrates how to write data back to the Analytic Workspace.

Drill Out from Crosstab Cell

Demonstrates how to drill out from a crosstab to a URL outside of the application, a new page displaying a related Graph, and to detailed data in a relational table.

UIX samples

Sample Description

Showing the use of multiple Look and Feels

Demonstrates how to change the look and feel of a UIX application.

Using a non-OLAP datasource with Graphs

Shows how to use the graph against a relational or an XML data source.

Java servlet samples

Sample Description

Connecting to Oracle 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.

Displaying Linked Views

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

Creating a Custom Query Tool

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."

Handling State Management

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

Using the Toolbar

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

Enabling Partial Page Rendering

Shows how to enable Partial Page Rendering on the Toolbar sample above.

Enabling Advanced Toolbar Links

Shows how to display advanced hyperlink on Format and Stoplight Tools, to access pages of the FormatCustomizer.

Creating a Multiple Page Application

Illustrates navigation among multiple pages in a BI Beans application, in this case, between two pages in a servlet. 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.

Other samples

Sample Description

Connection Pooling

Shows how to use connection pooling within BI Beans applications.

LDAP User Synchronization

Demonstrates how to synchronize users between the BI Beans Catalog and a LDAP server

Database User Synchronization

Demonstrates how to synchronize users between the BI Beans Catalog and a RDBMS

Before you begin

Before you can run the BI Beans samples, 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 Common Schema. This data set is used by the BI Beans samples and tutorials, as well as the samples and tutorials for 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 all the samples.

  1. In JDeveloper, expand the bibeans workspace, expand the catalog project, and then expand the Application Sources node.

  2. Right-click catalogBIDesigner1 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 catalog project and select Rebuild from the popup menu.

  7. Right-click the bibeans workspace and select Rebuild from the popup menu.

You are now ready to begin using the samples.

Note: To deploy any of the samples, you must first deploy the catalog.jpr project and make sure the runtime settings for the project is going against a BI Beans Catalog in a database. This is because each of the samples reference the following configration files under the catalog.jpr project for runtime connection to Oracle OLAP and the BI Beans Catalog: catalogOLAPConfig1.xml and catalogOLAPConfig1OLAP.dad.

Run the Samples

Run the Java Client Samples

In JDeveloper, expand the bibeans workspace and right-click the javaclient project. Select Run from the popup menu.

Run the JSP Samples

In JDeveloper, expand the bibeans workspace and the jsp project. Expand the Web Content folder, right-click on BIWriteback.jsp or on BIDrillOutHome.jsp and select Run from the popup menu.

Run the UIX samples

In JDeveloper, expand the bibeans workspace and the uix project. Expand the Web Content folder, right-click on graphRelationalXMLData.uix or changingLAF.uix, and select Run from the popup menu.

Run the Servlet Samples

In JDeveloper, expand the bibeans workspace and right-click the servlet project. Select Run from the popup menu.

Run the full Java Client and JSP application samples



Copyright © 2004 Oracle Corporation
All Rights Reserved