Categories of OLAP DML Data Types

Oracle OLAP workspace data types fall into categories, which are referred to as basic data types. They are listed in Table 2-1, "OLAP DML Basic Data Types".

Table 2-1 OLAP DML Basic Data Types

Basic Type	Specific Types
Numeric	`INTEGER`, `SHORTINTEGER`, `LONGINTEGER`, `DECIMAL`, `SHORTDECIMAL`, `NUMBER`
Text	`TEXT`, `NTEXT`, `ID`
Boolean	`BOOLEAN`
Date	`DATETIME`, `DATE`

Different objects support the use of different data types for their values:

For most values, including variable values, all of the data types are supported.
For dimension values, only the INTEGER, NUMBER, TEXT, ID, and NTEXT data types are supported.

Also, when you want an OLAP DML program to be able to handle arguments without converting values to a specific data type, you can specify a data type of WORKSHEET for the arguments and temporary variables in the program. Use the WKSDATA function to retrieve the data type of an argument with a WORKSHEET data type.