Plug-In Package Functions

The functions in this chapter represent the more advanced functions available in MicroStrategy, including data mining, financial, mathematical, and statistical functions. For more information on the plug-in functions and how to install the Function Plug-in Wizard, see Using Custom Plug-In Functions.

Each section briefly describes the category of function and then lists each function along with information designed to provide data necessary for understanding and implementing an individual function. The information provided for each function includes:

• An explanation of the data returned by the function
• The syntax of the function including function name, the available parameters, the parameter setting defaults, and the types of data possible for use with the function
• The mathematical expression illustrating exactly how the calculation is defined in MicroStrategy (if applicable)
• Usage notes describing any error conditions, invalid data types, or key items to know before using the function (if applicable)
• An example of the function in use; this can be either a report example or a simple text description of the data returned based on the specified input

For a list of databases and the functions they support, see MicroStrategy and Database Support for Functions.