Developing OLAP Objects

Overview

JDeveloper provides wizards that help users create OLAP objects, including crosstabs, tables, graphs, calculations, and queries. The definitions of these OLAP objects are stored in XML files that can be copied to the BI Beans Catalog. End users can then access these objects in the Catalog through a BI Beans application. This tutorial guides you through the process of setting up a BI Beans project, creating OLAP objects, and copying OLAP objects to the BI Beans Catalog. You will use these objects in the subsequent tutorials.

Prerequisites

This tutorial requires installing the demo database bibdemo schema and installing the BI Beans Catalog.

Exercises

Each tutorial consists of groups of exercises. Complete these exercises in sequence because later exercises depend upon previous exercises.

The exercises for this tutorial are as follows:

1. Setting Up Your Project
2. Creating Calculations
3. Creating Presentations
4. Using QueryBuilder
5. Formatting Presentations
6. Copying Objects to the Beans Catalog

Next Steps

After completing this tutorial, you will have a BI Beans project and a set of OLAP objects (crosstabs, graphs and calculations). At that time, you will be ready to develop applications that use these objects. The following tutorials guide you through the development of an HTML-client application and a Java-Client application:

• Developing a JSP Application
• Developing a Java-Client Application

Return to Tutorials Overview