The Case Data Model provides some basic operations that can be performed on data from CDM variables, such as adding, concatenating, and converting from one data type to another. The UNICOM Intelligence Function Library supplements these basic operations with some more advanced operations.

For more information about the UNICOM Intelligence Function Library, see UNICOM Intelligence Function Library.

The locale settings and MDM document specified in the Provider connection string are passed to relevant functions intrinsically. The variable ID of the current variable instance in the MDM document is also passed to relevant functions.

If you open the case data without specifying an MDM Document or an MDSC, you can use all of the functions except the DefinedCategories and DefinedElements functions. However, in this case you must always specify categories using their numeric category values and not using their names or a category expression to define one or more ranges of categories. For further details, see Value resolution.

For an introduction to using the functions in SQL queries, see I want to use the Data Model to access data, but I am used to SPSS-style data. Can you give me an overview?.