This function returns the number of security ranges
for the cube in the current database.
This function is designed specifically to allow you
to count the number of security ranges or rules that are written as
part of fact security for a cube in a specific database. It displays
the number of such security ranges in the specified cube in the specified
database.
The function has the following syntax:
Syntax: OLAPFactSecurityRuleCount
(database, cube )
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 the count and for returning the results
of this formula / instead enter the cell reference which has the
name of such a cube.
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.
- 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 OLAPFactSecurityRuleCount 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 counted and returned as
the result of this function.
=OLAPFactSecurityRuleCount
($B$1, $B$2) |
The above formula returns a value = 3; which
signifies that in the database "Acuity" (B1), in the cube
AP_Trans (B2) , there are 3 specified rules (ranges) that are created
as part of the security for that cube.