This function returns the first member in the specified
dimension. This function is designed specifically to allow you to
view specifically the first member in a specified dimension, in a
specified database, the index of which is built in the function and
pre-defined as 1.
The function has the following syntax:
Syntax: OLAPMemberFirst
(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 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 first member / alternatively
enter the cell reference in the Excel sheet which has the name
of such a dimension.
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.
- 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 OLAPMemberFirst function from the
list of functions provided and click "Ok".
- When building the formula enter the cell range
for the database name with the required dimension, and the dimension
name which has the member whose name you want to access. 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.
- In the following example B1 is the cell that
holds the database name, B4 is the name of the dimension from
which the member names will be accessed, and the member corresponding
to the index "1", that is the first member will automatically
be returned by this function.
=OLAPMemberFirst
($B$1, $B$4) |
The above formula returns a value = "Actual"
which signifies that in the database "Acuity" (B1), in the
dimension "Version" (B4), the member corresponding to the
index number "1" , which is indeed the first member of the
dimension, is the value returned by the function as displayed above,
i.e.., member name referenced as "Actual".