|Oracle9i OLAP User's Guide
Release 2 (220.127.116.11)
Part Number A95295-02
Oracle OLAP runs within the Oracle database kernel. An Oracle OLAP session is always connected to the database. You do not open a connection with the database as a separate or optional step.
You can move data between an analytic workspace objects (such as variables and dimensions) and relational tables in the following ways:
IMPORTcommand facilitates bulk data transfer from relational tables into the analytic workspace, and a new
SQL INSERT DIRECTcommand facilitates data transfer from the analytic workspace into relational tables.
CWM2_OLAP_AW_CREATE, provides procedures for creating an analytic workspace from relational tables and OLAP Catalog metadata, and for generating views of the workspace.
ODBC is not available, and thus access to third-party databases is not available directly from Oracle OLAP.
Oracle Express Relational Access Administrator and Oracle Express Relational Access Manager are not available.