This function returns the property value for a member,
for a property from a specified property group.
This function is designed specifically to allow you
to view the property values entered to a specific property group for
a specific member. The member belongs to a specified dimension in
a specified database. It returns the text that signifies a property
attribute of the member in that group.
The function has the following syntax:
Syntax: OLAPMemberProperty
(database, dimension, member, group)
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
wherein you want to access the name of the member / alternatively
enter the cell reference in the Excel sheet which has the name
of such a dimension.
- Member : Enter the name of the member which
exists in the dimension mentioned above and it is the member for
which you want to access the property values from a property group
/ alternatively enter the cell reference in the Excel sheet which
has the name of such a member as its value.
- Group : Enter the name of a property group
which exists in the above mentioned dimension and database. This
group should include the member mentioned above, and the property
value in text, for the member, will be displayed as the output
of the function.
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.
- The member specified in the "Member"
parameter should exist in the dimension that is mentioned above
and again must be referenced by the accurate and exact name.
- The name of the property group specified in
the "Group" parameter must also exist in the same dimension
and 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 OLAPMemberProperty function from
the list of functions provided and click "Ok".
- When building the formula enter the cell range
for the database name that contains the required dimension, and
the dimension name which has the member whose name you specify
next, and also the member name for which you are tracking the
property as its specified within the group in the dimension's
hierarchy and finally the name of the "Property Group"
from the value for property will be accessed. If you don't want
to manually enter the member name or the dimension name, you can
use the functions called OLAPMember and OLAPDimension respectively
in order to get this value and then use those cells as references
for the function.
- In the following example B1 is the cell that
holds the database name, B3 is the name of the dimension from
which the member names will be accessed, and C3 is the cell reference
for the member name whose property is tracked through the property
group specified here as "PropValue" and the property
is the value returned by this function.
=OLAPMemberProperty
($B$1, $B$3, $C$3, "PropValue") |
The above formula returns a value = "Currency"
which signifies that in the database "Acuity" (B1), in the
dimension "AP_TransMeasures" (B3), for the member "amount",
and from the property group called "PropValue", the corresponding
property is "Currency" as returned by the formula.