LINKDIM ​

This function is used with LINKDIM to ensure accurate calculation of LINKS. Provide this function with the name of the dimension which is being referenced and the relative location.

LINKDIM(dimension, relative_location)

LINKDIM(dimension, relative_location)

Parameters ​

• dimension - The dimension which the reference is providing.
• relative_location - The relative location in the source cube which will be evaluated and used as part of the location reference in the target cube.

Examples ​

LINKDIM("Account", ["No Time", "Account"])

LINKDIM("Account", ["No Time", "Account"])

Note: This will return the value in the Travel cube which is in the corresponding cell.

Assuming the cube with the formula is being applied to has only a Scenario dimension in common the target cube and the evaluated cell has a Scenario of Actual. It returns the value at the intersection of [All Travel, Total Expenditure, Actual] in the Travel cube.