CellText Using MemberOverride

MemberOverride can consist of one or more dimensions. It uses the following format:

DimensionName = MemberName, DimensionName = MemberName

where:

DimensionName is the name of an override dimension.

MemberName is the name of the override member for the dimension.

Follow these guidelines when you specify member overrides:

Table 28. CellText Examples Using MemberOverride

Example

Description

<<CellText(cur, cur, A, cur)>>

Existing syntax with no dimension override

<<CellText(cur, cur, A, cur, Scenario=Budget)>>

New syntax with one dimension override

<<CellText("Grid Name", 1, A, current, Value = "Entity Currency")>>

One dimension override using quotation marks in the member name

<<CellText("Grid Name", 1, A, cur, Value = Entity Currency)>>

No quotation marks in the member name that contains a space

<<CellText("Grid Name", 1, A, cur, "Value=$USD" = Entity Currency)>>

Quotation marks surrounding dimension name that contains an equal sign

<<CellText(Grid1, 1, cur, cur, Value = Entity Currency, Scenario=Actual)>>

Two-dimension override that uses a comma separator

<<CellText(Grid1, 1, cur, cur, Value = Entity Currency; Scenario=Actual)>>

Two-dimension override that uses a semicolon separator

<<CellText("Current", 34, BB, cur, "Value"= Entity Currency, Scenario=Actual; Period = Qtr3)>>

Three-dimension override that uses comma and semicolon separators

<<CellText(cur, 1(3), A(B), cur, 300 = ABC , "Americas, Value=(in $USD);" = "Entity Currency (USD)" , Scenario=Actual)>>

Four-dimension override