SE.COUNT

Returns the number of elements in a subset.

Syntax

SE.COUNT(Database alias,Dimension,Subset)

Dimension is the name of the dimension containing the subset whose elements you want to count and Subset is the subset whose elements you want to count.

Example

The Profit dimension of the Sales cube of the Best Practices sample database has a subset called Monetary. It contains 14 elements. This formula returns 14:

SE.COUNT("Best Practices OLAP","Profit","Monetary")

Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.

If an element does not exist or is not a member of Dimension, the function returns a #Value error.