MicroStrategy ONE

Function Syntax and Formula Components

You can use functions in any situations where you build an expression. Although an expression can have unique characteristics, there is a basic syntax for applying functions in expressions. The use of each function is described in detail in the rest of this book. This section covers the basics of functions and their key components.

Each function is designated by a function name. Functions operate on an argument that can be a fact, attribute, metric, or constant, and the function's behavior is often further specified using one or more parameters. Function parameters are used to fine-tune the behavior of functions. Arguments provide the inputs to functions.

In this guide, MicroStrategy functions are grouped into function types. This section provides information on function types, as well as their parameters and arguments.

This guide does not include information on Data Mining functions. This information can be found in the Data Mining Services chapter of the Advanced Reporting Help.