This function returns the weight of the child relative
to the parent in the dimension.
This function is designed specifically to allow you
to view the weight that is assigned to a specific detail level member
in relation to the parent member for a specified dimension in a specified
database. The function displays the integer for the weight of this
detail level member. The function takes as a parameter the name of
the database, the name of the dimension that has the members that
are to be accessed, the name of the parent member for which child
level members the weight will be tracked and the name of the child
level member, whose weight is the result returned by the function.
The function has the following syntax:
Syntax: OLAPWeight
(database, dimension, parent, child)
Explained below are the 4 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 members you wish to access /enter the cell reference which
has the name of such a dimension.
- Parent : Enter the name of the parent member
from which a relationship will be established to the below mentioned
child level member / enter the cell reference which has such a
member as its value.
- Child : Enter the name of the child level member
for which the function will read the weight in relation to the
parent level member specified above and this weight integer will
be the result of the function.
Remarks
- If a connection is not established with a database
the result will be a #value.
- The dimension and in it the member names for
both parent level members and child level members must exist within
this database and it should be referenced by the accurate and
exact name.
- 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 OLAPWeight function from the list
of functions provided and click "Ok".
- When building the function enter the cell range
for the database name, dimension name, and the parent member name
as well as the child member name. 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, B3 is the name of the dimension that
contains the parent member which is referenced as "Total_Measures"
and it also contains the child level member which is referenced
through the cell C3, through which relationship the function determines
the weight for the child level member which is the result that
the function displays.
=OLAPWeight
($B$1, $B$3,"Total_Measures", $C$3) |
The above formula returns a value = "-2"
which signifies that this is the weight for the child level member
"Amount" referenced as (C3) and this weight is established
through the relationship between this child and its parent called
"Total_Measures" , and both these members exist in the dimension
called "AP_Trans_Measures" (B3) which belongs to the database
"Acuity" (B1).