Metric Editor: Formula tab

Use the Formula tab to define the metric. The Formula tab contains the following:

• The Object Browser pane allows you to search for, locate, and select the objects to define the metric. It is located on the left side of the interface.

• The Shortcut Bar contains shortcut icons to commonly used folders, displayed in the default group My Shortcuts. You can customize the Shortcut Bar by adding, renaming, and deleting groups and folders. It is also located on the left side of the interface.

  The Shortcut Bar cannot be displayed unless the Object Browser is shown.

• The Metric definition area displays the complete metric definition, including its formula and calculation level, condition, and transformation components. It is located on the right side of the dialog box and is divided into the following panes:

• The Metric component pane, located under the heading "Metric (metric name) is defined as." It shows the metric definition split into the formula and the level (dimensionality), condition, and transformation components.

  • Click on the formula or one of the components to define that part of the metric. The Definition pane changes to reflect your selection.

  • If you select the metric definition itself, you can define the whole metric using MicroStrategy objects, identifiers, delimiters, and functions. See Metric Editor Formula tab: Identifiers and delimiters and Metric Editor Formula tab: Functions and operators for more information.

• The Definition pane at the bottom right of the dialog box. It displays the metric definition, formula, or component selected in the Metric component pane.

  • Drag objects such as attributes, metrics, filters, and so on from the Object Browser into this pane to define the metric.

  • The following topics describe the Definition pane as it appears for each component:

• Metric Editor Formula tab: Metric definition

• Metric Editor Formula tab: Formula definition

• Metric Editor Formula tab: Level definition

• Metric Editor Formula tab: Condition definition

• Metric Editor Formula tab: Transformation definition

When you create a new metric, the Metric definition area is blank. The Metric component pane displays "Metric definition is empty" and the Definition pane shows "Enter your formula here." Once you select an object or operator, the components are displayed in the Metric component pane and the definition is displayed in the Definition pane.

The Metric Editor also helps you identify simple versus compound metrics. When you collapse everything on a simple metric in the Metric definition area, its components are still visible. Since a compound metric does not contain these components at the level of the entire metric, you cannot see them. When you expand each expression of a compound metric, the components of each expression are displayed. For more information, see the Creating a Query chapter in the Basic Reporting Help.

Related Topics

• Functions and Operators

• Identifiers and delimiters

• Metric level property symbols

• Metric Editor: Layout

• Subtotals/Aggregation tab

• Creating metrics

• Creating simple metrics

• Creating compound metrics

• Formatting metrics (metric level formatting)