Accessing a Workspace from a Java Application

Typically, a Java application uses the OLAP API to access relational data. In addition, the Oracle OLAP API supports access to data that resides in an analytic workspace. The Oracle9i OLAP Developer's Guide to the OLAP API and the OLAP API Javadoc describe these activities.

Using OLAP Metadata

Through the OLAP API, a Java application can access workspace data that has been exposed in OLAP metadata. Because OLAP metadata is compatible with the OLAP API multidimensional metadata (MDM) model, a Java application can manipulate workspace data using OLAP API Java classes. For information on how a database administrator exposes workspace data in OLAP metadata, see the Oracle9i OLAP User's Guide..

Using Embedded OLAP DML Commands

The OLAP API provides a way for a Java application to directly manipulate workspace data, without the need for any metadata and without the use of the OLAP API data manipulation classes. The Java application uses the SPLExecutor class in the OLAP API to open a workspace and send DML commands directly to Oracle OLAP for execution in the workspace.