This function returns the count for the number of
groups in the current database. This function is designed specifically
to allow you to view how many user groups are defined in a specified
database during the task of securing the database and creating users
and user-groups for the same purpose. The function returns the number
of the total count of such user groups in the database. The function
takes as a parameter the name of the database which contains the user-groups
for securing the database.
The function has the following syntax:
Syntax: OLAPGroupCount
(database)
Explained below is the parameter that has to be provided
when building this function.
- Database : Enter the name of the database which
has security enabled and which consists of user-groups created
for securing the database / enter the cell reference which has
the name of this Database.
Remarks
- If a connection is not established with a database
the result will be a #value.
- The database that is specified for the "database"
parameter above, should have "security enabled" in order
for the function to list the count of the user-groups included
therein.
- 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 OLAPGroupCount function from the
list of functions provided and click "Ok".
- When building the formula enter the cell range
for the database name that has security enabled and contains one
or many user groups whose count you want to access as the result
of this function.
- In the following example B1 is the cell that
holds the database name, and this database has the user-group
/ groups, the count of which will be displayed as the result of
this formula.
The above formula returns a value = "2"
which signifies that in the database "Acuity" (B1), which
has security enabled, there are a total number of User-Groups to the
count of 3.