Skip Headers
Previous
Previous
 
Next
Next

About the OLAP DML

The OLAP DML is the native data definition and manipulation language for analytic workspaces. Its primary data structures are dimensions, variables, formulas, and value sets. These dimensional objects in an analytic workspace support the high-level dimensional objects in the database, such as cubes, cube dimensions, measures, attributes, and hierarchies. The OLAP DML is a mature language that was developed specifically for creating and managing dimensional objects and for manipulating dimensional data. Although programming in the OLAP DML requires significant skill, the language offers more power and flexibility than any other language.

The OLAP DML contains several programs that create and manage cubes, attributes, hierarchies, and other dimensional database objects. Oracle recommends that you use the OLAP DML only for implementing features that are not currently available in SQL Developer, such as forecasts and allocations.

You can use the OLAP DML in the following places:

Related Topics

"Creating OLAP DML Programs"