[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

CUBESETCOUNT

Syntax:

CUBESETCOUNT ( set )

Description: Computes the number of items in a set.

Arguments:

Name

Type

Description

set

text

An expression that evaluates to a set defined by the CUBESET function.

 

Return Type and Value: number – The number of items in a set.

[Example:

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

end example]