MicroStrategy ONE

Importing base formulas

A base formula allows you to reuse the formula in other metric definitions, instead of retyping or rebuilding it. A base formula used in a metric is linked to that metric as a shortcut.

If you import the base formula, as described in the following procedure, the shortcut is replaced with the actual formula definition. This removes the link to the saved base formula; any changes made to the base formula are not updated in the metric.

Prerequisite

You can import a base formula only if the metric already uses a base formula. For instructions, see Using base formulas in metrics.

To import a base formula

  1. Open the metric containing the base formula. (How?)

  2. In the Metric component pane (located under the heading "Metric (metric name) is defined as"), select Formula.

  3. From the Tools menu, select Import (base formula name).

    This option is available only if Formula is selected and the metric uses a base formula.

The shortcut to the formula is replaced with the actual formula definition, severing the link to the saved base formula.