In Oracle Hyperion Financial Management, Fusion Edition, you can add cell text for any valid cell in a data grid. At times, you may need multiple cell text entries to store different types of information for a Point of View intersection. The Enhanced Cell Text feature enables you to create multiple cell text entries and define cell text labels to easily identify types of information when you view cell text. You can use cell text labels in Financial Management Web data grids and data forms. Cell text labels are also supported in Oracle Hyperion EPM Architect, Fusion Edition, Oracle Hyperion Smart View for Office, Fusion Edition and Oracle Hyperion Financial Reporting, Fusion Edition.

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

These are the guidelines for defining cell text labels:

Example

For example, suppose an administrator has defined these cell text labels for an application. Users can select from the label list and enter the corresponding cell text data. When you view the cell text for a specific POV data cell, you would see this information:

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>

You load cell text labels as metadata. The Load dialog box now includes an option for cell text labels. When loading, you can use the Merge or Replace mode. If you use Replace mode, the system may delete cell text labels that are currently in use, resulting in orphaned cell text data in the application. You can also delete cell text labels at any time from the system even if they have cell text data assigned, resulting in orphaned cell text data. In these instances, you can use the “Clear Invalid Records” option in Database Management to clear invalid cell text data.

For details on loading metadata, see the Oracle Hyperion Financial Management Administrator’s Guide.

You can extract cell text labels as metadata. For details on extracting metadata, see the Oracle Hyperion Financial Management Administrator’s Guide.

You can load and extract cell text labels during the data load or extract process. To separate cell text content in the DAT file, you must use one of these delimiters: the pipe symbol (|) or the tilde (~).

Example:

!Descriptions
Actual;2011;February;Periodic;California;USD;Sales;[ICP None];GolfBalls;Customer2;[None];Increases;"MaturityDate~02/28/11|CouponRate~8%|Rating~AAA"

For details on loading and extracting data, see the Oracle Hyperion Financial Management Administrator’s Guide.

You can delete cell text labels from the system, even if they have cell text data assigned, which may result in orphaned data. To clear invalid cell text data, in the Database Management module, use the Clear Invalid Records option.

You can enter cell text information in Web data grids or Web data forms.

The cell text field can store as many characters as defined for the application. Maximum length for a cell text value is defined by the “MaxCellTextSize” application attribute.

You can enter any characters for cell text values and you can use spaces. However, you cannot include the pipe (|) or tilde (~) character if you used it as a delimiter for the cell text value in the load format.

For every application, there is a system-generated member for Cell Text Label named [Default]. If you want to enter only one cell text entry for a data cell, you can select the [Default] member to enter the cell text information. A cell can have either just one entry using the [Default] cell text label, multiple cell text label entries, or a combination of cell text labels and [Default] entries.

In addition to entering cell text in data grids or data forms, you can attach one or more documents to cells for additional detail. For example, you can attach a Microsoft Word document, Microsoft Excel spreadsheet, XSL, or RPT file. You can have a doc attachment for each cell text label per POV cell.

When you are creating Web data forms, you can allow users to define each column or row as cell text information instead of data.

If you enter a value of 0, 1, 2, or [Default] for cell text, the system returns the default cell text entry.

celltext:Label

Sample script:

C1=Y#CUR.P#CUR,CellText:MaturityDate

The Enhanced Cell Text feature includes three new rules for storing and retrieving multiple cell text entries and using cell text labels.

HS.GetCellTextWithLabel("POVExpression", "CellTextLabel")

HS.GetCellTextWithLabel("A.Sales.I#[ICP None].C1#[None].C2#[None].C3#[None].C4#[None]","Rating")

HS.ContainsCellTextWithLabel("POVExpression", “CellTextLabel”)

If HS.ContainsCellTextWithLabel ("A#Sales.C1#Prod1.C2#Region1", “Rating”) = "False" then ... End If

HS.SetCellTextWithLabel("POVExpression", "CellTextLabel", "CellTextString")

HS.SetCellTextWithLabel "A#Asset.I#[ICP None].C1#None.C2#None.C3#None.C4#None”, “Rating”, “AAA”

Cell text labels are now supported in Oracle Hyperion EPM Architect, Fusion Edition. See the Oracle Hyperion Enterprise Performance Management Readme 11.1.2.1.102 (11780153).

When you are working in Oracle Hyperion Financial Reporting, Fusion Edition, you can retrieve multiple cell text entries per Point of View. See the Oracle Hyperion Financial Reporting Readme 11.1.2.1.101 (11732644).

When you are working with Oracle Hyperion Financial Management, Fusion Edition data forms in Oracle Hyperion Smart View for Office, Fusion Edition, you can now retrieve multiple cell text entries per POV. See the Oracle Hyperion Smart View User’s Guide 11.1.2.1.101 (12398953).