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,
CellTextis properly evaluated if you use the following member override statement:"Scenario=Budget"
Table 11-7 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 |