OLAPMemberCount

Description:

This function returns a count of the number of members in the dimension. This function is designed specifically to allow you to count how many members exist within a specified dimension, in a specified database.

The function has the following syntax:

Syntax: OLAPMemberCount (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 and that you want to access / enter the cell reference which has the name of this Database.
• Dimension : Enter the name of the dimension which exists in this database mentioned above and is the dimension whose member you want to access to perform a count for the same / instead 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 must exist within this database and it should be referenced by the accurate and exact name.
• These 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 OLAPMemberCount 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. If you don't want to manually enter the member you can use another function called OLAPDimension in order to get this value and then use that cell as a reference for a formula.
• In the following example B1 is the cell that holds the database name, B5 is the name of the dimension from which the member names will be accessed, and the members will be counted to return a total number of members in this dimension.

=OLAPMemberCount ($B$1, $B$5)

 

The above formula returns a value = "18" which signifies that in the database "Acuity" (B1), in the dimension Time (Periods) (B5), the count for the total number of members in this dimension is 18, which is the value returned by the function as displayed above.