CellText Function with MemberOverride

The MemberOverride parameter 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 (" "), as in the following example:
"Entity"="Acme","Period"="Q1"
If you specify only one member override, do not include the separator character.
Dimension names and member names must be enclosed 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, the CellText function is properly evaluated if you use the following member override statement with it:
"Scenario=Budget"

The following table provides examples of ways to use the MemberOverride parameter in the CellText function:

Table 39. Examples of Using the MemberOverride Parameter

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 (which contains a space)
<<CellText("Grid Name", 1, A, cur, "Value=$USD" = Entity Currency)>>	Quotation marks surrounding dimension name which 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 semi-colon 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