MicroStrategy ONE

Transformation Expressions

Transformations are schema objects that use business rules to compare values at different time periods. A typical example of this type of analysis is a TY/LY comparison (This Year versus Last Year).

Transformations are schema objects; therefore, you must have the appropriate privileges to create or modify them.

There are two types of transformations: expression-based and table-based. Single-value functions can be used in expression-based transformations, and specifically in the definition of member expressions. These expressions define how (and from where) the information is retrieved for the transformation of the specified attribute.

For more information on transformations and their components, see the Advanced Reporting Help or the MicroStrategy online help.

To Access Functions in Transformations

  1. In the MicroStrategy Developer File menu, point to New > Transformation. The Transformation Editor is displayed. The Select Member Attribute dialog box also opens.
  2. Select the attribute on which to base the transformation and click OK. The Expression Editor opens.
  3. Build an expression for the transformation of the selected member attribute, accessing functions in one of the following ways:
    • Click (Insert Function) in the Definition pane. The Insert Function wizard opens.
    • Enter the function name and all required expression syntax directly in the Enter your formula here box.