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

- Sample descriptions

- Java-client
- JSP
- UIX
- Java Servlet
- Other

- Installing and running the samples

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

   - If you have not already created a connection named OLAPConnection1, choose New under the Datasource connection drop down.
   - Accept a default name for the new connection: OLAPConnection1.
   - On the Authentication tab, specify 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 `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

- Ad-Hoc Query and Analysis Tool

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

- Executive Insight Dashboard Application

  In JDeveloper, expand the `bibeans` workspace and right-click the `executiveInsight` project. Select Run from the popup menu. The starting page for this demo is `BIHome.jsp` under the Web Content folder.

- BI Beans JSP Tag Guide

  In JDeveloper, expand the `bibeans` workspace and right-click the `jspTagGuide` project. Select Run from the popup menu. The starting page for this demo is `index.html` under the Web Content folder.

Copyright © 2006 Oracle Corporation
All Rights Reserved