How to Increase Cell Text or Comments Field Size for Planning Web Forms


Setting the Maximum Length for Text Values and Comments in Cells

Users can add cell text values and comments to data form cells as described in the Oracle Hyperion Planning User’s Online Help. By default, the maximum number of single-byte characters allowed for text in each cell is 255, and the maximum number for comments is 1500. Note that, in the database, the column data type is set to varchar(255) and varchar(2000) by default.

If you need to display additional characters in cell text or comments, you can set these 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
To set the maximum length for text values and comments in cells:

1. Select Administration, then Application, and then Properties.

2. Select Application Properties.

3. Add the property by clicking Add, and then 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.

Updating these settings to more than 2000 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.
The table affected for cell text is HSP_TEXT_CELL_VALUE, and the column in VALUE

For e.g

You would need to update the database to support 2000 character limit on the table. You can use the following to make the change
ALTER TABLE hsp_text_cell_value MODIFY VALUE NVARCHAR2(2000)

Thanks,
~KKT~

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s