OLAP DML is Both a Data Definition Language and a Data Manipulation Language |
The OLAP DML is both a data definition language and a data manipulation language:
You use OLAP DML, itself, to create and modify analytic workspace and analytic workspace object definitions that the OLAP DML needs to execute. (See "Creating New Workspaces and Objects" and "Working with Previously-Defined Analytic Workspaces" for more information.)
However, the real power of the OLAP DML lies in its analytic powers. Using the OLAP DML you can:
Define special OLAP DML objects that specify complex calculations. (See "Creating Calculation Specifications" for a general discussion of this process.)
Write programs to perform complex analysis.You can write a OLAP DML programs to perform almost any type of complicated multidimensional analysis. For general information on creating an OLAP DML program, see Programs. For overview information on creating common types of OLAP DML programs, see "Common Types of OLAP DML Programs".