Practice free

Cube functions

Cube functions read values from an OLAP cube or the Data Model. They need a data connection, so they return errors in a plain workbook.

7 functions in this category.

Start here

All cube functions

FunctionWhat it doesLevelSinceSpills?
CUBEKPIMEMBER Pulls a key performance indicator defined in an OLAP cube, such as its goal or status, into a worksheet. Expert 2007 or earlier No
CUBEMEMBER Fetches a single item from a cube, such as one product or one year, so you can reference it in CUBEVALUE formulas. Expert 2007 or earlier No
CUBEMEMBERPROPERTY Reads an attribute, like a product's colour or a customer's city, attached to a cube member. Expert 2007 or earlier No
CUBERANKEDMEMBER Pulls the nth item from a cube set, handy for top-10 lists. Expert 2007 or earlier No
CUBESET Defines a group of cube members that other cube functions then count, rank, or list. Expert 2007 or earlier No
CUBESETCOUNT Counts how many members a cube set holds. Expert 2007 or earlier No
CUBEVALUE Returns a number such as total sales for a chosen year and region from a cube or the Data Model. Expert 2007 or earlier No

Other categories