This function returns the privileges of the point for
the user / group and cube in the in the current database. This function
is designed specifically to allow you to view the privilege / privileges
that would be the access level assigned to a user or a user group within
the specified database. The security privileges maybe assigned for a user
or a user group and it can apply to the entire database or a cube or a
specific point within that cube. However this function returns only those
privileges for the user / group which are pertaining to a specific point
within the database. The function tracks down this point through the parameters
for the names of the members that are provided to this function.
This function reads the security privileges for a specified
user or group, and the function returns back to the user the security
privileges which are applicable to the point in the cube tracked as explained
above.
The function has the following syntax:
Syntax: OLAPFactSecurityPrivileges
(database, cube, user/group, member1 to n…)
Explained below are the parameters that have to be provided
when building this function.
- Database : Enter the name of the database which
has the cube you want to access within which the fact security rule
is written / enter the cell reference which has the name of this Database.
- Cube : Enter the name of the cube which exists
in this database mentioned above and is the cube within which one
or more fact security rule / rules may be written and are to be accessed
by this function / instead enter the cell reference which has the
name of such a cube.
- RangeIndex : Enter the index of the range / fact
security rule that is written within the cube mentioned above and
which is the rule that you want to access. The rules written for fact
security in a cube are accessed sequentially in the order they are
written from top to bottom, numbered from 1 to n.
- User/Group : Enter the index of the name of a user
/ user group for whom you want to find out the fact security privileges
for a point in a cube.
- Members k1, k2, …k'n
: Enter the names of the members, one from each dimension in order
to establish a relationship to determine the exact intersection point
for where the function needs to ascertain the privileges for the user
or the group specified above / enter the cell references which have
such members as their value.
Remarks
- If a connection is not established with a database
the result will be a #value.
- The cube, the user or the group and the member
names that are given to the function as parameters must exist within
this database and should be referenced by the accurate and exact name.
- 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 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 OLAPFactSecurityPrivileges function
from the list of functions provided and click "Ok".
- When building the formula enter the cell range
for the database name and the cube name. If you don't want to manually
enter the parameter you can use another function called OLAPCube in
order to get the cube name from another Excel cell and then it's possible
to use that cell as a reference for a formula. Also enter the name
of the user or the group for whom you want to access the security
privileges and also enter the member names from the cube which help
ascertain the exact intersection for which the privileges will be
ascertained.
- In the following example B1 is the cell that holds
the database name, B2 is the name of the cube, next the name of the
user has been entered for whom the security privileges have to be
ascertained and the rest of the references are for the members names,
one from each of the dimensions in the cube, so as to identify the
exact point of intersection within the cube for which the function
has to ascertain the user's privileges.
=OLAPFactSecurityPrivileges ($B$1, $B$2,
"Vince", C3, C4, "Period_01" , A9) |
The above formula returns a value = "Read"
which signifies that in the database "Acuity" (B1), for the
user "Vince" the access privileges are "Read" when
they are pertaining to the cube "AP_Trans" (B2) and when the
intersection point for which the write access privileges are ascertained,
is the intersection of the members "Amount "(C3), "Actual"
(C4), "Period_01" and the vendor name referenced through A9
(ACS_Advanced Computer Solutions). The access privilege returned by this
function is pertaining to the point of intersection that is determined
above.
The function returns the value "Read"
as the result of the function.