MicroStrategy ONE

Accessing functions for a new metric

Use the Metric Editor to create new metrics and edit existing metrics in MicroStrategy. The interface allows you to build metric expressions and validate them.

  1. From the File menu on the MicroStrategy Developer, point to New and then select Metric. The New Metric dialog box is displayed.

  2. Choose a Metric template and click OK to proceed. The Metric Editor is displayed.

  3. Build the metric expression, accessing the functions in one of the following ways:

    • Expand the Functions and Operators folder using the drop-down list or shortcut list in the Object Browser pane. Then expand the Functions, Operators, or Plug-In Packages folder to access the various categories of functions and operators.

    • Click f(x) (Insert Function) in the Definition pane. The Insert Function wizard opens.

    • Type the function name and all required metric syntax directly in the Enter your formula here box.

You can also edit existing metrics by using the Metric Editor. To access the editor, select the appropriate metric in the folder list, object browser, or report view. Then right-click and select Edit from the shortcut menu. The Metric Editor opens with the selected metric loaded.