Specifying Typed Measures

Typed measures extend the analytical capabilities of Essbase. In addition to numeric values, measures can also be associated with text- or date-typed values.

The following general guidelines apply to both text and date measures:

  To specify a typed measure:

  1. Ensure that the typed measure that you will use exists in the Metadata Navigator.

  2. Access the member properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Member Properties Tabs.

  3. Select the Typed Measures tab.

  4. Optional: In the Member format string text box, enter an MDX expression to reformat the values in cells to be displayed in a desired format; for example, with a decimal point or a comma, or as text.

    Note:

    Do not confuse the member string format with derived text measures. See Creating or Editing Dimension Elements and Derived Text Measures.

    Note:

    The MDX expression cannot exceed 256 characters.

  5. In the Text List Association group, navigate to a text list.

  6. Select the text list.

    The text list name appears in the Current Assigned Text List field.

  7. Click Apply.