Link References
When to use: When making simple links/calculations between cells.
Description: The link function returns data from a specified cube at a relative location. If common dimensions exist, they can be excluded entirely from the relative location argument.
Simple Syntax
vb
LINK("SourceCubeName", ["Element 1", "Element N"])Example
Restrict to "Amount" Measure, Restrict to Account "Domestic Travel Spend"
vb
LINK("Travel Planning", ["All Trips", "Domestic Travel Spend"])Considerations
Besides having the ability to specify another cube to refer to the second argument of the LINK function behaves the same as a Direct Reference including the ability to prefix an element with its Dimension and/or Hierarchy.