This function returns the member for the specified alias of the specified dimension alias group. This function is designed specifically to allow you to view the member of an alias under a specific dimension specified in the function. The function displays the name of the member that corresponds to an alias from a specified alias group under the specified dimension.
The function takes as a parameter the name of the dimension which has the alias group with the aliases, the name of the alias group and the value for the alias that corresponds to any member, and the member name is the value that the function returns.
Syntax: ALIASTOMEMBER (Dimension, Group, Alias)
- Dimension : Enter the name of the dimension in the above mentioned database what has the Alias Group you want to access.
- Group : Enter the name of the Alias Group you want to access that exists in the dimension mentioned above.
- Alias : Enter the alias value that exists within the alias group mentioned above which exists in the specified dimension.
Remarks
- The name of the dimension must be a valid name and should exist in the database.
- There must be the same alias group existing in the database as entered for the Group parameter above.
- The value given as the parameter "alias" must be a valid value that exists within the dimension's alias group and this is the value corresponding to which the member from the dimension will be returned.
- All arguments are compulsory and neither argument is optional.
Example
=ALIASTOMEMBER ("Region", "Codes", "AS") |
- returns the member name corresponding to the alias "AS" from the Alias Group "Codes" which belongs to the dimension .Region ( the value returned is : "ASIA"). |
Note: The Alias Name must be spelled exactly as in the Alias Group. A number value that is an alias in an alias group should be entered as "characters".
Let us take the example of a cube in PowerOLAP which requires data that is the value for the member name corresponding to an alias which is accessed through its name and group and the dimension name which has the alias group, all of which are to be given as parameters to the function. If in the same dimension in another member or in another dimension in another cube, you want to display this accessed member name value for the alias supplied to the function then it is appropriate to use the ALIASTOMEMBER function to access the member for a given alias. In this case we can write a formula in the cube in PowerOLAP to access this value for the member belonging in a specific dimension and this can be accessed with the help of this function and written to another member that is supposed to hold this value as fact data or you can also write this value to a different member in a different dimension in another cube.
.png)
The screen above shows a formula for the ALIASTOMEMBER function. The formula writes a value into the "MetaDataValues" dimension, into the "AliasToMember" member. In the formula, the ALIASTOMEMBER function takes three parameters, which are, the name of the dimension whose alias groups are accessed, the name of the alias group which has the aliases you wish to access and the value for the alias corresponding to which a member name will be returned as the result of the function. This formula accesses the member name based upon these three parameters that are given calculating it from the alias name, the alias group and the dimension name. The function above accesses the alias groups from the "Time (Periods)" dimension, and from that dimension it accesses the "TimeCodes" alias group and the alias accessed is "P3" corresponding to which a member name "Period_03" is returned as the result of the function.