Of course all of these things are a possibe since the OLAP options is in the Oracle Database kernel and not a seperate process.

• You can FLASHBACK QUERY (re-run) a Multidimensional Datatype (aka Analytic Workspace) query.

• You can FLASHBACK TABLE (restore) an incarnation of a dropped Multidimensional Datatype from the Recycle Bin.

• You can use Datapump (IMPDP/EXPDP) to backup and recover Multidimensional Datatypes. You can also do this through OLAP DML and traditional imp/exp.

• You can use RESUMABLE_TIMEOUT to pause a build if you run out of storage until more is allocated.

• You can implement a Virtual Private Database (VPD) on a Cube or Dimension View. There is an internal mechanism to do this as well using the PERMIT command inside the Multidimensional Datatype.

• You can use the Job Scheduler (as part of Analytic Workspace Manager) to submit builds at specific times and concurrency.

• You can monitor Oracle OLAP option performance via Database/Grid Control using AWR or ADDM just as you would anything else. Of course you can since Oracle OLAP option uses the same memory and resources (SGA/PGA and Tablespace).

• You can use Real Application Clusters (RAC) with the Oracle OLAP option to scale-out Cube builds and querying users. Again restating the fact that the OLAP option is in the Database kernel and is not a seperate process.