Oracle® OLAP Java API Reference
11g Release 1 (11.1)


Oracle® OLAP Java API Reference.


Packages Contains classes that support processing in Oracle OLAP. Deprecated as of Oracle 11g, Release 1 (11.1); the classes in this package are replaced by classes in the package. This package is deprecated as of Oracle 11g Release 1 (11.1). Contains classes that support the execution of OLAP DML commands in Oracle OLAP.
oracle.olapi Contains an interface, an exception, and a class that are of general use in the OLAP API. Contains interfaces and classes for retrieving and accessing the result set of a query. Contains classes that construct a query of the data in an Oracle Database.
oracle.olapi.metadata Contains interfaces and classes that represent Oracle OLAP metadata objects and that provide those objects to an application.
oracle.olapi.metadata.deployment Contains classes that specify the deployment of a logical OLAP model as relational OLAP (ROLAP) objects or as analytic workspace (AW) objects.
oracle.olapi.metadata.mapping Contains classes that map the MdmObject objects of a logical OLAP model to physical storage structures in the Oracle Database.
oracle.olapi.metadata.mdm Contains classes that represent data supporting the multidimensional model (MDM) for metadata.
oracle.olapi.metadata.mtm Deprecated as of Oracle 11g, Release 1 (11.1); the classes in this package are replaced by classes in the oracle.olapi.metadata.deployment, oracle.olapi.metadata.mapping, oracle.olapi.metadata.mdm, and oracle.olapi.syntax packages.
oracle.olapi.resource Provides support for the internationalization of messages for Exception classes in the Oracle OLAP Java API.
oracle.olapi.session Contains a class that represents a connection to an Oracle Database instance.
oracle.olapi.syntax Contains classes that represent data types, functions, commands, and data objects.
oracle.olapi.transaction Contains interfaces that define classes that are involved in transactions between Oracle OLAP and an OLAP client application and Exception classes that an application might encounter.
oracle.olapi.transaction.metadataStateManager Contains an interface to implement and associate with a Template object.


Oracle® OLAP Java API Reference.

Juyy 12, 2007

This is the reference documentation for the Oracle OLAP Java API, the Java application programming interface for Oracle OLAP. The 11g release contains many changes in the Oracle OLAP Java API. The major changes are to the metadata model.

The API now includes classes that an application developer can use to define metadata objects, to map the objects to database tables and views, and to deploy the objects in an analytic workspace or as relational tables and views. With other classes the developer can load data into an analytic workspace, including data that results from a series of specified calculations.

In implementing the new metadata model, the oracle.olapi.metadata.mdm package has many new classes and new methods on many other classes. Additionally, the API includes the following new packages:

New Features

For a description of the new features of the Oracle OLAP Java API for this release, see New Features.

Compatibility with Previous Releases

Programs that use previous releases of the Oracle Java API can run on Oracle Database, 11g Release 1 (11.1). When creating a DataProvider, or a UserSession for a DataProvider, you can specify the type of metadata that Oracle OLAP recognizes and makes available to the client application. By default, Oracle OLAP recognizes 11g metadata. Through settings that you pass to a DataProvider or UserSession constructor, you can specify that Oracle OLAP recognize 9i or 10g metadata instead of 11g metadata. For information about the metadata reader mode and other settings, see the DataProvider class description.

Intended Audience

This documentation assumes that you are already familiar with Java, relational database management systems, data warehousing, and online analytical processing (OLAP) concepts. It is intended for Java programmers who are responsible for creating applications that create and maintain OLAP objects, build and maintain analytic workspaces,and perform online analytical processing.

Before You Begin

To use the Oracle OLAP Java API, you must have access to an Oracle Database instance that has the OLAP option installed. An Oracle Database with the OLAP option provides the Oracle OLAP Java API classes, and other required classes, in JAR files. Before you can compile an Oracle OLAP Java API program, you must get the required JAR files and add them to your Java development environment.

The following table lists the required JAR files and their location under the ORACLE_HOME directory in an Oracle Database installation.

File Name Location
  olap_api.jar   /olap/api/lib
  ojdbc5.jar   /jdbc/lib
  xmlparserv2.jar   /lib

You must use the JDBC files included in your Oracle Database installation and not those from another Oracle product or from another vendor.

For information on installing an Oracle Database with the OLAP option, see your Oracle Database installation documentation. For more information on administering the OLAP option, see Oracle OLAP User's Guide.

JDK Version Required

This release of the Oracle OLAP Java API requires J2SE Development Kit 5.0 (JDK 5.0).

Examples of Using the Oracle OLAP Java API

In the examples of the Oracle OLAP Java API code in this documentation, the metadata objects are mapped to columns of the tables of the Global sample schema. You can download SQL scripts that create the Global schema from the Documentation section of the Oracle Technology Network (OTN) Web site at

To download the sample schema, in the Documentation section select Sample Schemas for Documentation.

From the OTN Web site You can also download a compressed file that contains example programs that include the code from the examples in this documentation and the examples in Oracle OLAP Java API Developer's Guide. To download the example programs, in the Documentation section select Example Programs for Documentation.

For more information on the example programs, see Example Oracle OLAP Java API Programs.

Unique and Local Values in the Oracle OLAP Java API

The members of an Oracle OLAP dimension are often organized into one or more hierarchies. Some hierarchies have parent-child relationships based on levels and some have those relationships based on values. The Oracle OLAP Java API uses a three-part format to specify the hierarchy, the level, and the value of a dimension member, and thereby identify a unique value. The first part of a unique value is the name of the hierarchy object, the second part is the name of the level object, and the third part is the value of the member in the level. The parts of the unique value are separated by a value separation string, which by default is double colons (::). The following is an example of unique value in the YEAR level of the CALENDAR hierarchy of the TIME dimension:


The third part of a unique value is the local value. In the preceding example, the local value is CY2001, which is the identifier for the year 2001 in the Global schema. The Oracle OLAP Java API has classes and methods that you can use to get the local values of dimension members. See the descriptions of the MdmPrimaryDimension and MdmDimensionMemberInfo classes for more information about unique and local values.

An application can specify that Oracle OLAP use unique or local dimension hierarchy values by setting the HierarchyValueType property in a java.util.Properties object and using the Properties object to construct an DataProvider. The use of Model objects requires unique hierarchy values.

The selection of dimension members in the query must match the setting of the property. For a complex query, using unique dimension hierarchy values generally provides faster performance when Oracle OLAP fetches the data.

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Related Documentation

The following documentation is helpful when using Oracle OLAP.

Copyright © 2002, 2007, Oracle. All rights reserved.