This function returns the number of alias groups for
the specified dimension in the specified database. The OLAPAliasGroupCount
function is designed specifically to allow you to view how many alias
groups are created within a specified dimension within a specified
database. The function returns a number which is equal to the number
of Alias Groups created by the PowerOLAP user within PO-Modeler when
editing or creating a dimension.
The function has the following syntax:-
Syntax: OLAPAliasGroup
(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 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.
Remarks
- If a connection is not established with a database
the result will be a #value.
- If no alias group exists within the database
mentioned in "Database" parameter above then it the
formula returns a "0".
- Both the 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 OLAPAliasGroupCount 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.
- In the following example B1 is the cell that
holds the database name and B6 is the cell that holds the dimension
name which contains the Alias Group/groups whose count will be
returned by the formula.
=OLAPAliasGroup($B$1,
$B$6) |
The above formula returns a value = 1 which
signifies that there is only 1 Alias group for the dimension "AP_Vendor"(B6)
in the database "Acuity" (B1).