What is a Cross-Cube Formula?
A Cross-Cube formula, as the name implies, is a formula that can be used to calculate values in a Cube using data that resides from one or more Cubes; thus, formulas are “crossing” from one cube to another. The use of Cross-Cube Formulas can dramatically improve performance, enabling users to calculate values only for certain Member intersection points and show them in a “standalone” Cube, rather than design a single Cube that performs many calculations across all Member intersection points.
A currency exchange cube is an example of a cube that is employed in a cross-cube formula: historic and current exchange rate differential values could reside in this cube, and formula logic from another cube would use them to create ongoing calculations across multiple currencies in another cube.
