This function returns the name of the nth alias group
for the specified dimension in the specified database.
The OLAPAliasGroup function is designed specifically
to allow you to view the alias group names that are created
within a specified dimension within a specified database. The function
returns the alias group name which is specified by the PowerOLAP user
within the Modeler when editing or creating a dimension.
The function has the following syntax:-
Syntax: OLAPAliasGroup
(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 alias group that you want to access / enter
the cell reference which has the name of this Database.
- Dimension :& Enter the name of the dimension
in the above mentioned database which has the Alias Group you
want to access / enter the cell reference which has the name of
such a dimension.
- N : Enter the index number for the alias group
in the above mentioned dimension of the specified database / enter
the cell reference which has this index as a value.
Remarks
- If a connection is not established with a database
the result will be a #value.
- The value for parameter "n" must
be a positive real integer and should correspond to the value
that the function has to return.
- There must be an alias group existing in the
database mentioned in "Database" parameter above.
- All 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 OLAPAliasGroup function from the
list of functions provided and click "Ok".
- When building the formula enter the cell range
for the database name, the dimension name and type in the index
for the alias group.
- In the following example B1 is the cell that
holds the database name, B6 is the cell that holds the dimension
name, and the number 1 is the index of the alias group then name
of which will be returned by the formula.
=OLAPAliasGroup($B$1,
$B$6, 1) |
The above formula returns a value = "DataLoadCodes"
which is the value for the Alias Group at the index 1(n) in the database
"Acuity" (B1) in the dimension "AP_Vendor" (B6).