CellText

CellText is a text function that retrieves the textual content from any of the following database connections:

A Financial Management cell.
Planning cell annotations.
A Linked Reporting Object (LRO) from a Oracle Essbase cell (CellText applies only to a Cell note LRO). For more information, see the Oracle Essbase Database Administrator's Guide.

The row, column, and page arguments apply to the intersection in a grid that contains the linked text or note. The function syntax is:

<<CellText("GridName", Row, Column, Page)>>

Another flavor of the CellText function provides an override of the grid’s “natural” point of view (POV) to a member selection when a cell does not exist in a grid. The function syntax is:

<<CellText("GridName", Row, Column, Page, MembeOverride)>>

See CellText Function with MemberOverride for details.

Argument	Description
GridName	The name of a grid. This value must be enclosed in quotation marks
Row	Numeric value representing the row number of the grid. The first row in a grid has an index of 1, the second row has an index of 2, and so forth.
Column	A letter representing the column of the grid. The first column in a grid has an index of A, the second column has an index of B, and so forth.
Page	A numeric value representing the page dimension index of the grid. The first page dimension in a grid has an index of 1, the second page dimension has an index of 2, and so forth.
MemberOverride	A string of dimensions and corresponding member selections that overrides the CellText POV. See CellText Function with MemberOverride for details.
AllRows/AllCols	Keywords that allow for an all row or column reference.

Note:

If the row or column parameters refer to a segment that expands, the top-left expanded cell is used. You can refer to any expanded cell using the “range” notation.

Example

You want to display the text linked to a specific cell in a grid. To do this, first run the report and display it by selecting File, then Web Preview. Note the name of the grid, the page dimension that is selected, and the runtime row and column.

The following example shows a report with the linked text in the cell that is in row 21, column B of a grid and is on the first page dimension. The syntax is:

Note re: allocation for Y2002 <<CellText("mygrid",21,B,1)>>.

Tip:	To view result-time rows and columns, select View, then Row & Column Headers in Web Preview, then preview the report by clicking the Web Preview button.

Note:

This function only supports the Current keyword when used in a grid cell; not in a text box object, header, footer or otherwise. For information and examples, see Current / Cur Keyword.