Data Locks


An additional optimization can be applied to caching through the use of Data Locks.

 

 

 

How to set Data Lock

 

Step 1. Define Fact Security for the Cube:

1.   In the PowerOLAP ribbon, select Model tab and Cubes command.
The Cubes dialog box appears.

2.   Select a cube (in this example, Future Year Model is selected), and click the Fact Security button.

The Fact Data Security Rules dialog box will be displayed as shown below:

3.   Click Add button.
This adds a range name at the top of the right-hand side of the dialog box.

4.   Rename the range relevant to the security being created.
In the example below, Last Months Budget is created.

5.   Click the Build Range Reference button .
This will display the Build Range Reference dialog box.

6.   Select the Dimensions and Member of those Dimensions as shown in the succeeding images below:

In the given scenario, the Member Budget of the Actual vs Budget dimension and the Member March of the Month dimension has been defined.

7.   Click OK.
The Fact Data Security Rules dialog box will be displayed on the screen, as shown below:

8.   Click the Allows button.
This will add an Allows word in the statement found at the right-hand pane of the dialog box, as shown below:

9.   Click the Rights button.
The Specify Data Security Access Levels dialog box will be displayed on the screen, as shown below.
For this example exercise, create a fact security rule to allow the user called Test to have Read access to the Future Year Model cube.

10. In the Specify Data Security Access Levels dialog, click to select the user (e.g., Test).
Or you may click on the PowerOLAP button and pick a user or user group in the dialog that appears.

11. Select what access to apply for the user, as in this case, make sure that the Access level is Read (selected by default).

12. Click OK.
This will return the user to the Fact Data Security Rules dialog box. The defined Dimensions and Users or the defined range will be displayed on the screen.

13. Type a semi-colon at the end of the security statement:

14. Click the Check button to check if security statement is free from syntax errors.

15. Click OK.
This will close the Specify Data Security Access Levels dialog box and display back the Cubes dialog box.

 

Notes


Now that a security range has been defined, PowerOLAP® has a feature that allows user to lock that Data Range. By locking the Data Range, the user is determining or specifying that no one is allowed to modify the values within the range specified.

 

Step 2. Lock the data range:

16. From the Cubes dialog box (shown below), make sure that the appropriate cube is selected (as in the example, Future Year Model cube must be selected) then click the Data Locks button.

If you try to view the cube properties by clicking on the Properties button while the pertinent cube is selected, notice that the option Enable Caching is checked.

The Data Locks dialog box is displayed on the screen as shown below:

17. Select a defined Fact Security in the list. In this case, select the Last Months Budget that was earlier defined.

18. Click the Lock Button.

Notice that the Status is now changed to Locked, and the user who locked the cube is also displayed. In the example, it was the Administrator who performed the Data Lock.

19. Click OK.

20. Back in the Cubes dialog, click OK to close it.

 

 

 

Effects of Data Locks in Caching

 

The PowerOLAP® Caching Algorithm takes advantage of the knowledge that no one is allowed to ever change the values in the defined range (March, Canada). Therefore, by defining Data Locks and locking ranges of data within PowerOLAP®, users can optimize models by preserving the cache.