This function returns the number of parents of the
specified member in the specified dimension.
This function is designed specifically to allow you
to view how many parent level members there are for a specific child
level member in a dimension. The function displays the number of parent
level members for this child-level member that belongs to a specified
dimension in a database.
The function takes as a parameter the name of the
database and the name of the dimension and the name of the member
in that dimension which is a child level member and may belong to
one or more parent level members.
The function has the following syntax:
Syntax: OLAPParentCount
(database, dimension, member)
Explained below are the 3 parameters that have to
be provided when building this function.
- Database : Enter the name of the database which
has the dimension and alias group 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 members you wish to access /enter the cell reference which
has the name of such a dimension.
- Member : Enter the name of the member which
is a child level member and will belong to minimum one or more
parent members , which count you want to ascertain. / Enter the
cell reference that has the name of such a member.
Remarks
- If a connection is not established with a database
the result will be a #value.
- The dimension and in it the member name, must
exist within this database and it should be referenced by the
accurate and exact name.
- The member referenced in the "Member"
parameter should be a child (detail) member which will have one
or more than one parent member.
- All 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 OLAPParentCount function from the
list of functions provided and click "Ok". a enter the
cell range for the database name, the dimension name, and the
member name.
- When building the function enter the database
name, dimension name, and the member name whose parent level members
you wish to count. If you don't want to manually enter the dimension
name and the member name you can use another function called OLAPDimension
and OLAPMember respectively 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 that
contains the member which is referenced in B8 and through the
member the function determines the parents it has to count in
order to return the resultant value for this function.
=OLAPParentCount
($B$1, $B$5, $B$8) |
The above formula returns a value = "1"
which signifies that in the database "Acuity" (B1), in the
dimension Time (Periods) (B5), for the member Qtr_1 (B8) , there are
parents level members to the count of 1 and this member belongs to
this 1 parent alone.