Home > About OLAP Programming Lang... > About the OLAP DML
![]() Previous |
![]() Next |
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:
Build Specification: You can create programs that run in a build specification.
Calculated Measures: You can create calculated measures that execute an OLAP DML expression or function.
Related Topics