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:

If you specify two or more member overrides, separate them with a comma (,) or a semicolon (;) and enclose each dimension and member name in quotation marks (" "), For example:

"Entity"="Acme","Period"="Q1"
If you specify only one member override, do not include the separator character.
Enclose dimension names and member names in quotation marks (" ") if they contain any of the following characters: ; , = ( ) < >.
For a single member override, the parameter may be enclosed in quotation marks (" "). For example, CellText is properly evaluated if you use the following member override statement:

"Scenario=Budget"

Table -13 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