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.
-
From the File menu on the MicroStrategy Developer, point to New and then select Metric. The New Metric dialog box is displayed.
-
Choose a Metric template and click OK to proceed. The Metric Editor is displayed.
-
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.