Understanding Label Only Members

Label only members have no associated data. Use them to group members or to ease navigation and reporting from Spreadsheet Add-in. Typically, you should give label only members the “no consolidation” property. See Setting Member Consolidation.

You cannot associate attributes with label only members. If you tag a base dimension member that has attribute associations as label only, Essbase removes the attribute associations and displays a warning message.

A descendent of a label only member cannot be tagged as Dynamic Calc. In the following example, when verifying the outline, Essbase issues an error message indicating that ChildB cannot be tagged as label only:

ParentA = Label Only
   ChildB = Label Only
      DescendantC = Dynamic Calc

Tagging DescendantC as Store Data or Dynamic Calc and Store resolves the issue.

  To tag a member as label only, see “Setting Member Storage Properties” in the Oracle Essbase Administration Services Online Help.