Microsoft Corporation
August 1999
Summary: This article provides a downloadable sample of Microsoft® SQL Server™ 7.0 OLAP Services files. It creates an OLAP Manager add-in that enables you to use the user interface to view and update cell security statements. (2 printed pages)
Cell security is enabled in Service Pack 1 for Microsoft® SQL Server™ version 7.0 Online Analytical Processing (OLAP) Services. The sample provided creates an OLAP Manager add-in that enables you to use the user interface to view and update cell security statements. You can also use it as a sample on how to write an add-in for OLAP Manager.
When you run the sample code, a Cell Security menu item will appear in OLAP Manager. You can access it by right-clicking a cube, the Roles folder under a cube, or a cube role. If no roles are used in a cube, this menu item will be unavailable (that is, grayed or dimmed).
The add-in will bring up a dialog box that lists all roles associated with the cube. When you select a role, the dialog box shows the cell security clauses specified for that role for this cube. You can also edit the cell security clauses in the dialog box.
Finally, the updated information can be stored back in Decision Support Objects (DSO).
For more information about cell security, see "OLAP Services Cell-Level Security" at www.microsoft.com/SQL/productinfo/celllevel.htm, available on the SQL Server Web site.
These OLAP Services sample files are contained in the following sample:
Click to open or copy the utilities discussed in this technical article.
Once the files have been downloaded, review the readme.txt file, as it provides instructions and prerequisites that you will need for use with the sample. Compile the CellSecurityAddin DLL (SecurityAddin.vbp) in Microsoft Visual Basic® 6.0, Professional Edition or Enterprise Edition. Double-click the CellSecurity.reg file to set up the add-in for use in the OLAP Manager administration interface of OLAP Services.