UNICOM Intelligence Function Library

Developer Documentation Library > UNICOM Intelligence Function Library

The UNICOM Intelligence Function Library (mrFuncLib.dll) supplements the basic expression evaluation with some more advanced operations.

Function	See
Operate on categorical data only	Categorical functions
Operate on text or categorical data, or arrays	Text, categorical, and array functions
Operate on only text data	Text functions
Operate on date and time data	Date and time functions
Convert data from one data type to another	Conversion functions
Generate random numbers	Random number functions
Order and retrieve items from category lists, arrays, and collections of objects	List functions
Mathematical functions	Mathematical functions
Other functions	Miscellaneous functions

If an MDM Document is specified when the connection is made to the Data Model, the MDM Document is passed to relevant functions automatically. 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, when you connect without specifying an MDM Document or an MDSC, 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. Similarly, in mrScriptBasic you can specify categories using their names or category expressions only when an MDM Document is available to the mrScript Engine. When an MDM Document is not available to the mrScript Engine, you must specify categories using their numeric category values. For more information, see Value resolution.

Dates and times and numeric data that contains decimal symbols and thousands separators are presented differently in different international locations (called locales). (You typically specify the locale on your PC using Regional Options in the Windows Control Panel.) The Case Data Model uses two different locale settings (called the input locale and the output locale) in order to handle situations where, for example, a questionnaire is presented in one language and answered in another. These settings can be defined as connection properties when you connect to the UNICOM Intelligence Data Model. For more information, see Locale handling in the UNICOM Intelligence Data Model. The input locale and output locale are automatically passed to the functions and are used when necessary for interpreting input data and formatting output data and error messages.

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?.

For information about adding function libraries, see Adding function libraries.

Additional data management functions (DataManagementFuncLib.dll) are also available. For more information, see Data Management functions.