This function returns the security privileges for
the user or group for the dimension in the current database.
This function is designed specifically to allow you
to see what kind of security has been attached to a dimension in the
database you are connecting to. The function takes as a parameter
the name of the database, the name of the dimension and the name of
the user / group for which you want the security displayed.
The function has the following syntax:
Syntax: OLAPDimensionSecurity
(database, dimension, 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 dimension that you want to access / enter the cell reference
which has the name of this Database.
- Dimension : Enter the name of the dimension
which has security associated with it, and this security is for
a user or a 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 dimension 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 database mentioned above and
should have been assigned security privileges of some kind to
the dimension in the dimension parameter.
- 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 OLAPDimensionSecurity 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 dimension name,
or you can manually enter the database and cube name. If you don't
know the dimension name in a particular database, you can also
first access the dimension name through the OLAPDimension 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 B5 is the cell that holds the dimension
name which has security enabled for a user referenced as "Jack"
here whose security privileges we want displayed.
=OLAPDimensionSecurity
($B$1, $B$5,"Jack") |
The above formula returns a value = "Read"
which signifies that in the database "Acuity" (B1), for
the dimension "Time (Period)" (B5) the user called "Jack"
has Read permissions.