About Measure Hierarchies

Measure hierarchies are used by Essbase Studio Server to create the accounts dimension in the Essbase model. If your data contains more than one measure (data value), then define a measure hierarchy and add all measures to that hierarchy

Essbase Studio has the following guidelines for measure hierarchies.

Oracle recommends that a measure hierarchy be created from a fact table. The measure hierarchy may also include user-defined members. However, a measure hierarchy can also be created from dimension tables, and it may also include user-defined members.

In summary, although Oracle recommends that measure hierarchies be created from columns in the fact table, Essbase Studio does not prevent you from creating measure hierarchies from dimension tables or from user-defined members. If the column header type is text, Essbase Studio will build a text list.

Note:

Text lists larger than 1024 KB can cause deployments to abort.