This function returns the text of the security range
for the cube in the current database.
This function is designed specifically to allow you
to the script written in the cube when creating a rule for fact security
for a database. It displays the complete text which forms part of
the fact security rule. The index for the fact security rule is specified
.
The function has the following syntax:
Syntax: OLAPFactSecurityRule
(database, cube, index )
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 that you want to access / 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 whose fact security
rules are the base for returning the results of this formula /
instead enter the cell reference which has the name of such a
cube.
- Index : Enter an index for the rule which is
included as one of the several rules which form the fact security
in the cube specified above. This is the range, the text of which
will be displayed as the result of the function.
Remarks
- If a connection is not established with a database
the result will be a #value.
- The cube must exist within this database and
it should be referenced by the accurate and exact name.
- The value for the parameters that take an "Index"
must be a positive real integer and should correspond to the argument
that you want to access for the function to return appropriate
values.
- 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 OLAPFactSecurityRule 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 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, B2 is the name of the cube, 1 is the
index of the "Rule" in the fact security for this cube
and the text of this rule will be displayed as the result.
=OLAPFactSecurityRule
($B$1, $B$2,1) |
The above formula returns a value = All
and {} allows {Jack} to Write ; which signifies that in the database
"Acuity" (B1), in the cube AP_Trans (B2) , for the 1st
rule, this is the text that makes up the rule, which is basically
allowing user "Jack" to have write access to all the members
of the cube.