Function parameters

Parameters determine how functions perform calculations. Any function, whether standard or user-defined, can have parameters, which are contained within angle brackets <> in an expression. If more than one parameter is used, they are separated by commas.

Function parameter notations are only displayed in the MicroStrategy Developer interface if the parameter settings are changed from the default and you have set your View option to Show Function Parameters.

You define parameters in the Function Name Parameters dialog box, which displays the tabs Parameters, Break By, and Sort By. For steps on how to access this dialog box and how to set function parameters with the Insert Function Wizard, see Accessing function parameters.

A functions available parameters are displayed in the Parameters tab. If a function has additional parameters, such as BreakBy and SortBy, the related tabs are displayed accordingly. The following subsections discuss the three tabs in more detail.

The details of each function are covered in this help, including a listing and description of each parameter that is available for the function. All parameters are listed within angle brackets <> as part of the function syntax. To review the details on the parameters available for each function, review the functions provided in:

• About basic functions

• About Date and Time functions

• About Apply, Banding, and Case functions

• Null/Zero functions

• About OLAP functions

• Rank and NTile functions

• About string functions

• Financial functions

• Mathematical functions

• Statistical functions