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
- CUBESET
Defines a group of cube members that other cube functions then count, rank, or list.
- CUBEVALUE
Returns a number such as total sales for a chosen year and region from a cube or the Data Model.
- CUBEKPIMEMBER
Pulls a key performance indicator defined in an OLAP cube, such as its goal or status, into a worksheet.
- CUBEMEMBER
Fetches a single item from a cube, such as one product or one year, so you can reference it in CUBEVALUE formulas.
- CUBEMEMBERPROPERTY
Reads an attribute, like a product's colour or a customer's city, attached to a cube member.
- CUBERANKEDMEMBER
Pulls the nth item from a cube set, handy for top-10 lists.
All cube functions
| Function | What it does | Level | Since | Spills? |
|---|---|---|---|---|
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
- Lookup and reference functions
43 functions
- Math and trig functions
80 functions
- Logical functions
19 functions
- Text functions
48 functions
- Date and time functions
25 functions
- Statistical functions
111 functions
- Financial functions
56 functions
- Information functions
21 functions
- Database functions
12 functions
- Engineering functions
54 functions
- Web functions
3 functions
- Compatibility functions
41 functions
- Add-in and automation functions
5 functions