This function calculates the number of items in the specified set.

Syntax

CUBESETCOUNT(set)

Arguments

For the argument, you can specify any string that assess set or reference to cell containing CUBESET function.

Remarks

This function returns a temporary message "#GETTING_DATA..." in the cell while being evaluated and before all the data in the cell is retrieved.

Data Types

Accepts only string data.

Examples

CUBESETCOUNT(A3)

CUBESETCOUNT(CUBESET("Sales","[Product].[All Products].Children","Products",1,"[Measures].[Sales Amount]"))

Version Available

This function is available in product version 11.0 or later.