About Typed Measures
Text measures are tagged "text" in the measures dimension. They enable cell values to contain one of an enumerated list of text labels defined at the outline level, using a mapping artifact called a text list. Date measures are tagged "date," enabling cell values to be 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,
-
In the Essbase web interface, open the outline for editing.
-
Click Outline Properties.
-
On the General tab, change the value for Typed Measures Enabled from False to True.
-
Click Apply and Close.
-
Click Save, and close the outline editor tab.
-
-
Text and date measures functionality applies to both aggregate storage and block storage applications.