In Oracle11g, the following changes were made to the Oracle OLAP DML:
Table Privileges Needed When Working With Analytic Workspaces
Additional Support for Grouping Ids
Increased Support for Explicit Looping
Aggregation Improvements
Support for Analytic Workspace Caching
Support for Multi-Step Analytic Workspace Build Process
Additional Data Types
New SQL-Like Functions
Support for Materialized Views
Nested Composites Are No Longer Supported