OLAPFactSecurityStatus

Description:

This function returns the locking status for a fact security rule of the range in the cube in the current database.

This function is designed specifically to allow you to view the current status associated with a rule / range specified and written as part of fact security for a cube in a specific database. It displays the status tag that is currently attached to the rule that is referenced in the function. Additionally, a user can modify the locked status of the range if they have the correct permissions. This can be done by double clicking on the function and then changing the currently specified data lock by selecting from the drop down selection of the Change Lock dialog that appears.

The function has the following syntax:

Syntax: OLAPFactSecurityStatus (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 status of the rule as it stands currently and as is associated with this rule 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.
• All 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 OLAPFactSecurityStatus 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 and the index number for the rule whose status you want returned as a value. If you don't want to manually enter the parameter for the cube name 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, and 3 is the index of the rule / range which is accessed by the function to return the current status of the rule.

=OLAPFactSecurityStatus($B$1,$B$2,3)

 

The above formula returns a value = " Unlocked"; which signifies that in the database "Acuity" (B1), in the cube AP_Trans(B2), for the range / rule for fact security, standing at the index 3, the current status as it stands is "Unlocked".

To change the current data lock status, double click on the cell containing the OLAPFactSecurityStatus function, in the above scenario it is the cell with the return value 'Unlocked', and then from the Change Data Lock dialog box that appears, select a new data lock status from the drop down menu. You can select from the Unlocked, Reserved, Locked and Committed options. Then Click OK.