Excel 2010 includes a set of functions called cube functions that you can use to query data
stored in certain databases. Cube functions are designed to work with Online Analytical
Processing (OLAP) databases. OLAP databases differ from relational databases such as
Microsoft Access, in that they store data, relationships, and hierarchies in multidimensional
structures know as cubes instead of in two-dimensional tables. Using data from OLAP
database sources speeds up the process of querying data because the server hosting the
database, not Excel, does a lot of the processing for you. When you import data into a
workbook from an OLAP database, Excel brings it in as a PivotTable or a PivotChart.
Note: An in-depth discussion on OLAP databases and cubes is beyond the scope of
this course. For more information on these topics, please visit office.microsoft.com.
Excel 2010 includes seven cube functions you can use to query data stored in OLAP
CUBEKPIMEMBER Returns a key performance
indicator property and the
name of the indicator in a
kpi_name, kpi_property, [caption])
Will help identify whether
or not a particular member
belongs to a cube.
one step further and
returns a specified
property value for the
specified member if it
exists in the cube.
ection, member_expression, property)
Returns the specified
ranked members of a cube
set. This can be useful for
identifying top- or bottom-
performers from within
tion, set_expression, rank, [caption])
Defines a calculated set of
set_expression, [caption], [sort_order],
Returns the value of the
number of items in a set.
Do Not Duplicate or Distribute