OLAP DML Data Types |
Workspace data types fall into categories, which are referred to as basic data types. They are listed in Table: OLAP DML 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.