Typed measures extend the analytical capabilities of Essbase. In addition to numeric values, measures can also be associated with text- or date-typed values.
Text measures are tagged as “text” in whichever dimension measures are represented. They enable cell values to contain one of an enumerated list of text labels. These labels are defined, at the outline level, using a mapping artifact called a Text List object.
Date measures are tagged as “date” in the dimension where measures are represented. Date measures enable cell values in the form of a formatted date.
If your Essbase model contains a date measure, be sure to review the information in Deploying Cubes before you deployment.
The following general guidelines apply to both text and date measures:
Add them to the existing measures dimension; for example, Accounts.
Do not aggregate them. By default, text and date measures are assigned the non-aggregation symbol (^).
Queries should be made at the same level at which data was loaded.
To specify a typed measure:
Ensure that the typed measure that you will use exists in the Metadata Navigator.
Access the member properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Member Properties Tabs.
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. |
In the Text List Association group, navigate to a text list.
The text list name appears in the Current Assigned Text List field.