1. Administrator's Guide
  2. Getting Started with Planning
  3. Setting Application and System Properties
  4. Setting the Maximum Length for Text Values and Comments in Cells

Setting the Maximum Length for Text Values and Comments in Cells

Users can add cell text values and comments to form cells as described in the Oracle Hyperion Planning User's Guide. By default, the maximum number of single-byte characters allowed for text in each cell is 255, and the maximum number for comments is 1,500.

Note:

In the database, the column data type is set to varchar(255) and varchar(2,000) by default.

If you need to display additional characters in cell text or comments, you can set these Oracle Hyperion Planning application properties to the maximum length required by your application:

  • MAX_CELL_TEXT_SIZE: Text values entered in cells whose data type is set to text

  • MAX_CELL_NOTE_SIZE: Comments added to cells

Updating these settings to more than 2,000 requires that you make a corresponding change to the database. If you increase the maximum number of characters allowed for cell text, you must alter the database column size or type to support the changed size. (Changing the column type to CLOB, NCLOB, TEXT, or NTEXT to accommodate large cell text size can affect performance. Do so only if your application requires large cell text entries.) For additional information, see the documentation for your database.

To set the maximum length for text values and comments in cells:

  1. Select Administration, then Application, and then Properties.
  2. Select Application Properties to set properties and values for a Planning application.
  3. Add the property by clicking Add, and enter one of these properties in the blank row:

    • MAX_CELL_TEXT_SIZE

    • MAX_CELL_NOTE_SIZE

  4. Enter a value in Property Value to represent the maximum number of single-byte characters allowed for text values or comments in each cell.
  5. Optional: If you are updating both of these properties, repeat step 3 and step 4 for the other property.
  6. Click Save and confirm your changes.
  7. Stop, and then restart the Planning server.
  8. Back up the database, and then update the database column size or type to support the changed size specified in this property. For additional information, see the documentation for your database.