About 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.

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.

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.

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

• Add them to the existing measures dimension; for example, Accounts.

• Do not consolidate them. By default, text and date measures are assigned the never consolidate operator (^).

• If the measure is not designed to be consolidated, queries should be made at the same level at which data was loaded.

• After you enable an outline to support typed measures, it cannot be reverted back to an outline that does not support typed measures.

• If you need to enable your outline to support typed measures,

  1. In the Essbase web interface, open the outline for editing.

  2. Click Outline Properties.

  3. On the General tab, change the value for Typed Measures Enabled from False to True.

  4. Click Apply and Close.

  5. Click Save, and close the outline editor tab.

• Text and date measures functionality applies to both aggregate storage and block storage applications.