This function returns the security privileges for
the user or group for the slice in the current database.
This function is designed specifically to allow you
to see what kind of security has been attached and the privileges
associated with a specific user or group, pertaining to a saved slice
that is part of a cube that exists within the database you are connecting
The function takes as a parameter the name of the
database, the name of the slice and the name of the user / user group
in the database, for which the privileges have to be returned.
The function has the following syntax:
(database, slice, 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.
- Slice Name : Enter the name of the saved slice
which has security enabled and wherein some privileges are assigned
to the user / user group mentioned below and whose security privileges
you want displayed / enter a cell reference which has the name
of this specific slice.
- User / User Group Name : Enter the name of
the user or the name of a user-group whose security privileges
you want displayed.
- If a connection is not established with a database
the result will be a #value.
- The name of the slice must be a valid name
and therefore the slice has to be a saved slice, 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 in the database, and should have been assigned
some security privileges for the slice mentioned above.
- These arguments are compulsory and neither
argument is optional.
This function may be easier to understand with an
- 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 OLAPSliceSecurity 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 slice name,
or you can manually enter the database and slice 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, "SecureSlice" is the name of
the slice which is saved and which has security specified for
it, and this slice has security for a user referenced as "Administrator"
here whose security privileges we want displayed.
($B$1, "SecureSlice", "Administrator")
The above formula returns a value = "Design"
which signifies that in the database "Acuity" (B1), for
the slice "SecureSlice", the user called "Administrator"
has design level security privileges.