MicroStrategy ONE

Showing function parameters

Parameters determine how functions perform calculations and are contained within angle <> brackets in an expression. If more than one parameter is used, the settings are separated by commas. For example, the formula of a rank function on the Revenue metric is displayed as Rank(Revenue) without parameters. When parameters are displayed, the formula is displayed as Rank<ASC=False>(Revenue), because it is sorted in descending order.

By default, the parameters for a function are not displayed. If you show function parameters, any function parameters that are not using default values are displayed.

For background information on functions, see Using functions in MicroStrategy.

To show function parameters

  1. Open the Metric Editor. (How?)

  2. Select the metric definition or the formula, not a component, in the Metric component pane (located under the heading "Metric (metric name) is defined as").

  3. From the View menu, select Show Function Parameters.

    You can also click the Show Function Parameters icon on the toolbar.

If the parameters are hidden, the Metric Editor displays them; if the parameters are already displayed, the option is named HideFunction Parameters and the Metric Editor hides them.

Related Topics