This function returns the number of dimensions of
the specified database.
This function is designed specifically to allow you
to view how many dimensions there are under a specific dimension.
The function displays the number of dimensions and it takes as a parameter
the name of the database.
The function has the following syntax:
Syntax: OLAPDimCount
(database)
Explained below is the 1 parameter 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.
Remarks
- If a connection is not established with a database
the result will be a #value.
- The argument is compulsory and not 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 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 OLAPDimCount 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, along with the path for the same.
- In the following example B1 is the cell that
holds the database name.
The above formula returns a value = 6 which
signifies that in the database "Acuity" (B1), there are
dimensions to the count of 6.