Relative percent adjustment

The relative percent adjustment method spreads values to the leaves of a consolidation by applying a percentage adjustment to the leaves of a reference cell.

The spread code for relative percent adjustment is R%. For more information, see Spreading command codes.

Example

This example takes the value of the reference cell's analogous leaf cell for each leaf cell in the consolidation, adds 20%, and adds the total to the leaf cell in the current consolidation.

POST api/v1/Cellsets('AAAAAA')/tm1.Update
{
    "BeginOrdinal":0,
    "Value":"R%+20"
    "ReferenceCell@odata.bind":
    [
        "Dimensions('A')/Hierarchies('A')/Elements('E1')",
        "Dimensions('B')/Hierarchies('B')/Elements('E2')",
        "Dimensions('C')/Hierarchies('C')/Elements('E3')"
    ]
}