This function returns the security privileges for
the user or group for the cube in the currently specified database.
This function is designed specifically to allow you to see what kind
of security has been attached to a cube in the database you are connecting
to.
The function takes as a parameter the name of the
database, the index number for the cube from within the database,
the name of which you want displayed.
The function has the following syntax:
Syntax: OLAPCubeSecurity
(database, cube, user/group)
Explained below are the 3 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.
- Cube Name : Enter the name of the cube which
has the user / user group whose security privileges you want displayed
/ enter a cell reference which has the name of this specific cube.
- User / User Group Name : Enter the name of
the user or the name of a user-group whose security
privileges you want displayed.
Remarks
- If a connection is not established with a database
the result will be a #value.
- The name of the cube must be a valid name and
should exist in the database to which a connection is made.
- The user name or the name of the user group
must exist as entered, within the cube mentioned above.
- These 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 OLAPCubeDimension function from
the list of functions provided and click "Ok".
- When building the formula enter the cell range
for the database name, and the cell range for the cube name, or
you can manually enter the database and cube name. If you don't
know the cube names in a particular database, you can also first
access the cube name through the OLAPCube function and then reference
that cell in this function where it asks for cube name.
- Also enter the user name or the name for the
user-group whose security privileges you want displayed. Instead
of manually entering the value, you can reference a cell that
has this value or you can use the OLAPUser OLAPGroup or OLAPUserGroup
function to access this value and then reference it.
- In the following example B1 is the cell that
holds the database name, and B2 is the cell that holds the cube
name which has a user referenced as "Jack" here whose
security privileges should be displayed.
=OLAPCubeSecurity
($B$1, $B$2,"Jack") |
The above formula returns a value = "Design" which
signifies that in the database "Acuity" (B1), in the cube
"AP_Trans" (B2) the user called "Jack" has design
Privileges assigned to him.