MicroStrategy ONE

Consolidation Element Expressions

Consolidations enable you to group attribute elements for use in a report, without changing the structure of your metadata or your warehouse definition. The elements contained in a consolidation are called consolidation elements (CEs). Only single-value functions can be used in the definition of a consolidation element as well as calculations between consolidation elements. A consolidation element expression defines how the attribute elements are calculated.

Only the basic mathematical operators (+, -, *, /) can be used through MicroStrategy Developer to define consolidation elements. Examples of consolidations, using these operators, are as follows:

  • CE01 = {Region = North-East}
  • CE02 = {Region = Mid-Atlantic}
  • CE03 = ({CE01} – {CE02})/{CE02}

Other single-value functions can also be used for consolidation elements, but only through the SDK.

The following examples demonstrate definitions using functions and calculations:

  • CE04 = Ln({Region = North-East})
  • CE05 = Ln({Region = Mid-Atlantic})
  • CE06 = Abs({CE04} – {CE05})

For more information on consolidations, see the MicroStrategy Advanced Reporting Guide.

To Access the Consolidation Element Expressions

  1. In the MicroStrategy Developer File menu, point to New > Consolidation. The Consolidation Editor opens.
  2. Double-click Click here to add new consolidation element.
  3. The New Consolidation Element pane is enabled. Build the expression for the new element.

You must drag and drop attributes into the Enter your expression here box. Only the operators can be typed directly in the box.