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
-
Open the metric containing the base formula. (How?)
-
In the Metric component pane (located under the heading "Metric (metric name) is defined as"), select Formula.
-
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.