OLAPCube

Description:

This function returns the name of the nth cube in the currently open database specified in the parameter. This function is designed specifically to allow you to view the names of cubes at a specified index in a specified database. The function takes as a parameter the name of the database and the index number for the cube from within the database, the name of which you want displayed.

The function has the following syntax:

Syntax: OLAPCube (database, n)

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 cube name that you want to access / enter the cell reference which has the name of this Database.
• N : Enter the index number for the cube that you want displayed, which exists in the database mentioned above.

Remarks

• If a connection is not established with a database the result will be a #value.
• The index number for the cube must be a valid number and should not be a number that is smaller or greater than the cubes existing in the database.
• The value for parameter "Index" must be a positive real integer and should correspond to the cube, the name of which the function has to return.
• 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 OLAPCube function from the list of functions provided and click "Ok".
• When building the formula enter the cell range for the database name, and type in the index number for the cube whose name you want displayed.
• In the following example B1 is the cell that holds the database name, and 1 is the index of the cube which you want to access.

=OLAPCube ($B$1,1)

The above formula returns a value = AP_Trans which signifies that in the database "Acuity" (B1), at the index level "1" , the cube which exists is "AP_Trans" .