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 | Description |
---|---|
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. |
|
Demonstrates how QueryBuilder functionality can be used in different contexts. This sample explores the QueryBuilder methods that enable simplified access to QueryBuilder functionality. |
|
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 |
|
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. |
|
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. |
|
Demonstrates how to link queries and selections between views (for example, crosstab, table and graph). |
|
Demonstrates how to generate a graph using the QueryBuilder and Graph format panels. |
|
Demonstrates how to create a custom wizard for end users to define new, data-aware crosstabs and graphs. |
|
Shows how an application can incorporate the BI Beans Print, Page Setup, and Preview dialogs to print crosstabs. |
|
Introduces a number of BI Beans Catalog features in an application, including the following:
|
|
Shows how to create two BI Beans Catalog connections and how to copy objects among multiple catalogs. |
|
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). |
Sample | Description |
---|---|
A complete interactive dashboard application that demonstrates the different analytic features of BI Beans |
|
A set of JSP pages that demonstrate the BI Beans JSP tag library: List tags, dialog and wizard tags, and general tags. |
|
Demonstrates how to write data back to the Analytic Workspace. |
|
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. |
Sample | Description |
---|---|
Demonstrates how to change the look and feel of a UIX application. |
|
Shows how to use the graph against a relational or an XML data source. |
Sample | Description |
---|---|
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. |
|
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. |
|
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." |
|
Demonstrates how to manage state for a BI Beans application, including support for the browser's Back button and for bookmark navigation. |
|
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. |
|
Shows how to enable Partial Page Rendering on the Toolbar sample above. |
|
Shows how to display advanced hyperlink on Format and Stoplight Tools, to access pages of the FormatCustomizer. |
|
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. |
Sample | Description |
---|---|
Shows how to use connection pooling within BI Beans applications. |
|
Demonstrates how to synchronize users between the BI Beans Catalog and a LDAP server |
|
Demonstrates how to synchronize users between the BI Beans Catalog and a RDBMS |
Before you can run the BI Beans samples, you must perform the following installation and configuration tasks:
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.
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.
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.
In JDeveloper, expand the
bibeans
workspace, expand the
catalog
project, and then expand the Application Sources
node.
Right-click catalogBIDesigner1 and select Settings from the popup menu.
Specify the Oracle OLAP data source connection:
Choose OK to close the BI Beans project settings.
From the File menu, choose Save All.
Right-click the catalog
project and select Rebuild
from the popup menu.
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
.
In JDeveloper, expand the bibeans
workspace and right-click the
javaclient
project. Select Run from
the popup menu.
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.
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.
In JDeveloper, expand the bibeans
workspace and right-click the
servlet
project. Select Run from the
popup menu.
In JDeveloper, expand the bibeans
workspace and right-click
the adhoc_tool
project. Select Run
from the popup menu.
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.
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 © 2004 Oracle Corporation
All Rights Reserved