MicroStrategy ONE

Formula Join Type for Compound Metrics

A compound metric contains multiple expressions or metrics. You can define how these elements are joined using the Metric Formula Join Type dialog box. This dialog box is accessed from the Advanced Settings option in the Tools menu of the Metric Editor. The join types for a metric base formula are as follows:

  • A default join is a join that is defined in each element.
  • An inner join includes only data that is common across all elements.
  • An outer join includes data that apply to every metric in a report.