|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
Upgrading From Express Server, 3 of 7
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.
CNV_CWM.TO.ECMcreates an ECM-type analytic workspace from relational tables.
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.