This function returns the nth member in the dimension.
This function is designed specifically to allow you
to view any member in a specified dimension, in a specified database,
the index of which is also specified as a parameter when building
this function.
The function has the following syntax:
Syntax: OLAPMember
(database, dimension, n)
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 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 member you want to access through the index parameter /
instead enter the cell reference which has the name of such a
dimension.
- N : Enter the index of the member that resides
in the dimension above. The member corresponding to this index
number will be the value returned by 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 value for the parameter "n" that
is the "Index" must be a positive real integer and should
correspond to the member, whose name you want to access through
this function and it's the value that the function has to return.
- 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 OLAPMember 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. If you don't want
to manually enter the member you can use another function called
OLAPDimension in order to get this value and then use that cell
as a reference for a formula.
- Also enter an index number as a value for the
parameter "n" which signifies that the member name that
the function should return will correspond to the index specified.
- In the following example B1 is the cell that
holds the database name, B6 is the name of the dimension from
which the member names will be accessed, and the member corresponding
to the index "9" is the one whose name will be returned
by this function.
=OLAPMember
($B$1, $B$6, 9) |
The above formula returns a value = "AtlTrade_AtlanticTrade
Shows" which signifies that in the database "Acuity"
(B1), in the dimension AP_Vendor (B6), the member corresponding to
the index number "9" is the value returned by the function
as displayed above.