This function returns the number of subsets in the
specified dimension. The OLAPSubsetCount function is designed specifically
to allow you to count the number of subsets existing in a given dimension
of a specified database. This function returns a number that equals
the total count of subsets in that dimension.
The function has the following syntax:
Syntax: OLAPSubsetCount
(database, dimension)
Explained below are the 2 parameters that have to
be provided when building this function.
- Database : Enter the name of the database which
has the dimension that you want to access / enter the cell reference
which has the name of this Database.
- Dimension : Enter the name of the dimension
in the above mentioned database whose subsets you want the function
to count / enter the cell reference which has the name of such
a dimension.
Remarks
- If a connection is not established with a database
the result will be a #value.
- The dimension specified must exist in the database
to which a connection is established and the dimension name should
be referenced exactly as it stands in the database.
- Both arguments are compulsory and neither argument
is optional.
Example
This function may be easier to understand with an
example.
- In order to build this function with more ease,
open the specific database and bring a slice from that database
into Excel. In this way you will have connected to PowerOLAP because
you now have the OLAPOpen formula automatically on your sheet
when you bring a slice of the cube into Excel.
- In Excel, use the menu: Insert -> Function
and select PowerOLAP from the drop down list.
- Choose the OLAPSubsetCount function from the
list of functions provided and click "Ok".
- When building the formula enter the cell range
for the database name and the dimension name for which the function
counts the subsets. If you don't want to manually type in the
dimension name, use the OLAPDimension function and access the
dimension name through this function and reference the cell with
this value when building this function.
- In the following example B1 is the cell that
holds the database name and B5 is the cell that holds the dimension
name for which this function counts the total number of subsets
and this counted number is the value that will be returned by
the function.
=OLAPSubsetCount($B$1,
$B$5 |
The above function returns a value = "
2 " which is the total count of subsets belonging to the dimension
Time (Periods) (B5) in the database "Acuity" (B1).