Please note javascript is required for full website functionality.
MVP

Blog

A to Z of Excel Functions: the CUBESETCOUNT Function

19 March 2018

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the CUBESETCOUNT function.

 

The CUBESETCOUNT function

When the workbook is connected to a Microsoft SQL Server 2005 Analysis Services or later data source, this function returns the number of items in a set.

The CUBESETCOUNT function employs the following syntax to operate:

CUBESETCOUNT(set)

The CUBESETCOUNT function has the following arguments:

  • set: this is required and represents a text string of a Microsoft Excel expression that evaluates to a set defined by the CUBESET function
  • set can also be the CUBESET function, or a reference to a cell that contains the CUBESET function.

It should be further noted that:

  • the CUBESETCOUNT function is supported only when the workbook is connected to a Microsoft SQL Server 2005 Analysis Services or later data source
  • when the CUBESETCOUNT function evaluates, it temporarily displays a "#GETTING_DATA…" message in the cell before all of the data is retrieved.

Please see my examples below: 

=CUBESETCOUNT(A3)

 

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

 

We’ll continue our A to Z of Excel Functions soon.  Keep checking back – there’s a new blog post every business day.

Newsletter