This function returns "True" if the user
or group can add dimensions or cubes in the current database This
function is designed specifically to allow you to view whether or
not an individual user or a group has certain access rights that entail
adding dimensions or creating cubes. The function returns 2 values
"True" if the specific user or group has the permission
to add dimensions and cubes and false if the user / group cannot do
the same for a specified database. The function takes as a parameter
the name of the database and the name of the user or the group as
created whose security privileges you wish to check.
The function has the following syntax:
Syntax: OLAPCanAddDimensionsAndCubes
(database, user/group)
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.
- User / Group : Enter the name of the user in
this database or the name of a User Group which exists in this
database mentioned above /enter the cell reference which has the
name of such a user or user group.
Remarks
- If a connection is not established with a database
the result will be a #value.
- There must be the same user or user-group existing
in the database as entered for the Group parameter above.
- Both 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 OLAPCanAddDimensionsAndCubes function
from the list of functions provided and click "Ok".
- When building the formula enter the cell range
for the database name and typein the name for the user or the
user group in that database whose security privileges you wished
to view. If you don't want to manually enter the user or the user-group
name you can use another function called OLAPGroupor OLAPUser
in a cell to get this value and then use that cell as a reference
for a formula.
- In the following example B1 is the cell that
holds the database name, and "Administrator" is the
user whose permissions and rights are being checked.
=OLAPCanAddDimensionsAndCubes($B$1,"Administrator") |
The above formula returns a value = "TRUE"
which signifies that in the database "Acuity" (B1), the
user "Administrator" has been granted the necessary permissions
to add cubes and dimensions.