|Oracle9i OLAP Services Developer's Guide to the OLAP DML
Release 1 (9.0.1)
Part Number A86720-01
Basic Concepts, 3 of 5
There are three situations where you might use the OLAP DML:
The most common types of calculations that the OLAP DMS is used for includes:
In addition, the OLAP DML can be used when you want to perform calculations that are not easily accomplished in the ETL process or using the OLAP API.
Because analytic workspaces are not stored in the relational database, it is possible for you to commit data to the analytic workspace without committing it to the data warehouse. This is very useful for work in process. For example, you might have a forecasting application where you want to allow users to save personal forecasts and reuse them during a later session, but you do not want that user to commit the forecast to the data warehouse.