Introduction to Analytic Workspaces

Conceptually, an analytic workspace is that portion of Oracle Database that is used by Oracle OLAP to perform OLAP analysis. Physically, an analytic workspace is stored in the Database as LOBs in a table named AW$workspacename.

An analytic workspace also contains the following types of objects and the OLAP DML definitions for these objects:

• Multidimensional data objects that contain the data that you want to analyze and the results of the analysis.

• Calculation objects (that is, formulas, models, aggregations, and allocations) that contain OLAP DML statements that specify the analysis that you want.

• OLAP DML programs that perform complex analysis.