Defining Cell Text Labels

You can add cell text for any valid cell in a data grid or form. At times, you may need multiple cell text entries to store different types of information for a Point of View intersection. You can create multiple cell text entries and define cell text labels to easily identify types of information.

Before users can enter multiple cell text entries, the administrator must define cell text labels. The labels are loaded as metadata. They apply to all account cells in the application, and are available for selection when users enter cell text information. See the Oracle Hyperion Financial Management User's Guide .

These are the guidelines for defining cell text labels:

• The label name can be a maximum 80 characters. It must be unique within a data cell.

• It can contain spaces but cannot start with a space. If you are using an Oracle database, labels cannot contain spaces.

• The label name cannot contain these characters:

  • Ampersand (&)

  • Asterisk ( * )

  • At symbol ( @ )

  • Comma ( , )

  • Curly brackets ( { } )

  • Double quotation mark ""

  • Forward slash (/)

  • Less than symbol (<)

  • Minus sign (-)

  • Number sign ( # )

  • Period (.)

  • Pipe character (|)

  • Plus sign (+)

  • Semicolon ( ; )

  • tilde character (~)

You can load cell text labels as part of a metadata load in a Cell Text Labels section in the load file. The following example shows a sample load file section for cell text labels:

<MISC Name="CellTextLabel">

<MISCENTRY>

<LABEL>MaturityDate</LABEL>

</MISCENTRY>

<MISCENTRY>

<LABEL>CouponRate</LABEL>

</MISCENTRY>

<MISCENTRY>

<LABEL>ExchangeRate</LABEL>

</MISCENTRY>

<MISCENTRY>

<LABEL>Rating</LABEL>

</MISCENTRY>

<MISCENTRY>

<LABEL>InterestRate</LABEL>

</MISCENTRY>

</MISC>