This function returns the number of property groups
for the specified dimension in the specified database.
The OLAPPropertyGroupCount function is designed specifically
to allow you to view how many Property groups are created within a
specified dimension within a specified database. The function returns
a number that is equal to the number of Property Groups created
by a PowerOLAP user within PO-Modeler when editing or creating a dimension.
The function has the following syntax:
Syntax: OLAPPropertyGroupCount
(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 property groups 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 which has the Property Group you
want to access / 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.
- If no Property group exists within the database
mentioned in "Database" parameter above then it the
formula returns a "0".
- Both the 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 OLAPPropertyGroupCount 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.
- In the following example B1 is the cell that
holds the database name and B3 is the cell that holds the dimension
name which according to you would contain the Property Group /groups
whose count is the value returned by the function.
=OLAPPropertyGroupCount
($B$1, $B$3) |
The above formula returns a value = 1 which
signifies that there is only 1 Property group for the dimension "AP_Trans_Measures"(B3)
in the database Called "Acuity" (B1).