This function returns the name of the security range
for the cube in the current database This function is designed specifically
to allow you view the name of a specified rule written as part of
fact security for a cube in a specific database. It displays the name
that was specified as the name to reference the rule by. This is the
name that was specified by the creator of that rule at the time it
was created.
The function has the following syntax:
Syntax: OLAPFactSecurityRuleName
(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 the index of the rule created
for fact security in the cube specified above. The name for the
rule corresponding to this index will be returned by 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.
- Both 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 OLAPFactSecurityRuleName 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 which has fact
security rules (ranges) that are accessed for returning the value
of the name of a rule written for fact security and this rule
is accessed here by the index 3.
=OLAPFactSecurityRuleName
($B$1, $B$2, 3) |
The above formula returns a value = " Rule9";
which signifies that in the database "Acuity" (B1), in the
cube AP_Trans(B2), the rule for fact security, standing at the index
3 is referenced by the name "Rule9" as named by the creator
of the rule.