LINK

This function is used to link cubes. For example this function would be used in a Profit and Loss model to bring the Operating Expenditure from other cubes such as Travel, Salary and Wages, Capital Expenditure and Sales or Revenue Planning

LINK(cube_name, relative_location)

Parameters

• cube_name - The cube to source information from.
• relative_location - The relative location in the target cube. The relative location needs to specify each of the elements of dimensions which exist in the source cube which do not exist in the destination cube.

Examples

LINK("Travel", ["All Travel", "Total Expenditure"])

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.