Creating or Editing Derived Text Measures

Derived text measures are text measures whose values are governed by a predefined rule expressed as a range. For example, a derived text measure called “Sales Performance Index,” based on a measure Sales, could be defined to display “High,” “Medium,” and “Low” depending on the range in which the corresponding sales values fall.

To create or edit a derived text measure:

Note:

When derived text measures are used in cube schemas to build Essbase models, the “XOLAP Model” option is unavailable for the model.

  To create a derived text measure:

  1. In the Metadata Navigator, right-click on the folder where you want to store the derived text measure and select New, then Derived Text Measure.

  2. In the Properties dialog box, enter a Name and optional Description for this derived text measure.

  3. To create the expression on which to base the derived text measure, drag the appropriate numeric source column from the list of tables and columns in the Formula list and drop it in the Expression box.

    The Functions and Operators tabs and their corresponding elements are not available for derived text measures.

    Note:

    You cannot create expressions for derived text measures from elements in text file data source connections.

    Essbase Studio does not verify cycle dependencies between metadata elements. Cycle dependency is a relationship between metadata elements that cycles back upon itself. See Cycle Dependency Guidelines for more information.

  4. In Range, click the plus sign (+) sign and enter ranges and their corresponding text value.

    Click the plus sign (+) to enter each new range on the next row.

    The text values you enter in the Label column will appear in a report if this derived text measure is used in a cube schema that is later deployed as an Essbase cube.

    You can enter precise numeric range values, as shown in Table 1, or use the range keywords, as shown in Table 2.

    Following is an example set of ranges for sales figures:

    Table 1. Ranges Using Precise Numeric Values

    From Value

    To Value

    Label

    025000Poor
    2500175000Good
    75001100000Excellent

    Table 2. Ranges Using Range Keywords

    From ValueTo ValueLabel
    below25000Poor
    2500075000Good
    75000aboveExcellent

    To use range keywords:

    1. In the From Value column, click in the cell to activate the drop-down and select <below> from the list.

    2. In the To Value column, click in the cell to activate the drop-down and select <above> from the list.

  5. Optional: Associate any applicable alias sets with the dimension element, as described in Creating or Editing Alias Set Bindings for a Given Alias Set.