LINKBY References
When to use:
Either:
- 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.
- 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.
Description: The LINKBY function us used when retrieving values based on either a Mapping or a value held within this cube. The function can (but doesn't have to) refer to cells in another cube. The initial two arguments are the same as the link function. The third, fourth and fifth arguments are the relative location of the value to assist in locating a destination cell in the source cube. The fourth and fifth arguments are optional and can be excluded altogether.
Syntax - Scenario A
vb
LINKBY("SourceCubeName", ["Element 1", "Element N"], LINKDIM("Dimension 3", ["Element 3"]))Syntax - Scenario B
vb
LINKBY("SourceCubeName", ["Element 1", "Element N"], MAPPING("Mapping Name", "LR"))The second argument to mapping is the direction:
- LR - Left to Right
- RL - Right to Left