OLAP Function Summary

There are seven recognized “CUBE” functions that can be used in cell formulas. These functions enable formulas in any cell to fetch data from Analysis Services. Specifically, the functions can fetch any member, set, aggregated value, property, or KPI from the OLAP cube. Because it is formula-driven, the layout of this data is as flexible as cells and formulas. The OLAP data can be placed anywhere on the spreadsheet, intermingled with other local calculations or within other formulas.

The function names are: CUBEKPIMEMBER, CUBEMEMBER, CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, and CUBEVALUE.