Cross-cube Formula

From OLAP

Jump to: navigation, search

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 other 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.

Personal tools