OLAPDimension

Description:

This function returns the name of the indexed dimension in the currently open database.

This function is designed specifically to allow you to view the name of the dimension in a specified database.

The function takes as a parameter, the name of the database and the index number for the dimension whose name the function has to return.

The function has the following syntax:

Syntax: OLAPDimension (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 dimension name that you want to access / enter the cell reference which has the name of this Database.
• N : Enter the index of the dimension in the database specified above, the name of which you want displayed.

Remarks

• If a connection is not established with a database the result will be a #value.
• The argument is compulsory and not optional.
• The value for parameter "n" must be a positive real integer.

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 OLAPDatabase 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 OLAPDimension function from the list of functions provided and click "Ok".
• When building the formula, enter the cell range for the database name or you can manually enter the database name.
• Also enter the index number for the dimension whose name you wish to access. The dimensions in any database are numbered sequentially from 1 to n, in the order in which they are created.
• In the following example B1 is the cell that holds the database name, and 3 is the index number for the dimension, corresponding to which the dimension name will be returned by the function.

=OLAPDimension($B$1, 3)

 

The above formula returns a value = "Time (Periods)" which signifies that in the database "Acuity" (B1), there exists a dimension called "Time (Periods)" that corresponds to the index supplied above as a parameter, which is 3.