LINKBY

Create a flow of information into the affected cells from the specified cubes using on a specified relative cell value as an element (on a dimension) in the target cube.

LINKBY(cube_name, relative_location, value_location_a, value_location_b, value_location_c)

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.
• value_location_a - A LINKDIM or MAPPING value.
• value_location_b - A LINKDIM or MAPPING value. (optional)
• value_location_c - A LINKDIM or MAPPING value. (optional)

Examples

LINKBY("SourceCubeName", ["Element 1", "Element N"], LINKDIM("Dimension 3", ["Element 3"]))

Note: Scenario A: When a part of the information needed to reference the target cell is held in the data of the current cube against a string-type measure.

LINKBY("SourceCubeName", ["Element 1", "Element N"], MAPPING("Mapping Name", "LR"))

Note: Scenario B: When linking to another cube via a mapping object. Mapping objects are used when the relationship between two cells is not easily supported by other referencing options. (See also MAPPING).