|Oracle9i OLAP User's Guide
Release 2 (22.214.171.124)
Part Number A95295-02
The OLAP DML can be used when you want to perform calculations that are not easily accomplished in the ETL process or using SQL (either directly or using the OLAP API). The results can be calculated as part of the data warehouse build and update process, and can optionally be written to SQL tables. Alternatively, applications developers can create OLAP DML programs using the OLAP Worksheet and execute them by embedding OLAP DML in their SQL- or Java-based applications.
OLAP Worksheet is an interactive command line interface to Oracle that you can use to perform the following tasks:
OLAP Worksheet has a command input window and a program edit window.
To open OLAP Worksheet, use the following steps:
Once you have opened OLAP Worksheet, you can use its menus to establish a connection to Oracle, open a workspace, execute OLAP DML commands, execute SQL statements, or write OLAP DML programs, save any changes, and close the connection.
Applications developers can embed OLAP DML in their SQL- or Java-based applications:
SPLExecutorclass in the OLAP API.