This function returns the Alias from the specified
alias group for the member in the dimension of a specified database.
This function is designed specifically to allow you
to view the alias (names) values entered to a specific alias group
for a specific member. The member belongs to a specified dimension
in a specified database. It returns the text that signifies the alias
attribute of the member in that alias group.
The function has the following syntax:
Syntax: OLAPMemberToAlias
(database, dimension, group, member)
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.
- Group : Enter the name of an Alias group which
exists in the above mentioned dimension and database. This group
should include the member mentioned below, and the alias name
for that member in text will be displayed as the result of the
function.
- 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 alias name values from an existing
alias group / alternatively enter the cell reference in the Excel
sheet which has the name of such a member as its value.
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 alias 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 OLAPMemberToAlias 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 alias value as its specified in the dimension.
- Finally enter the name of the "Alias Group"
from where the value for the alias name 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. You can also use the function
OLAPAliasGroup to access the alias group name and then use the
cell which has this value, and refer it in the formula.
- 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 A12 is the cell reference
for the member name whose "alias" is tracked through
the alias group specified here as "DataLoadCodes" and
the alias name is the value returned by this function.
=OLAPMemberToAlias
($B$1, $B$6, "DataLoadCodes", $A$12) |
The above formula returns a value = "45"
which signifies that in the database "Acuity" (B1), in the
dimension "AP_Vendor" (B6), for the member "AdvCons_AdvantageConsulting"
(A12) ,the corresponding Alias name for the same is as returned by
the formula, i.e.., 45.