Usage Note 38756: Using the SECURITY_SUBSET feature of SAS® OLAP Server
SAS® 9.2 provides a new feature called Security Subsets. This feature is enabled in your OLAP cube by building the cube with the SECURITY_SUBSET=YES option in your OLAP procedure code, or by unchecking the option to include secured member values in presummarized computations within the Cube Designer found in SAS OLAP Cube Studio and SAS Data Integration Studio.
Enabling this option allows the SAS OLAP Server to exclude secured members from a parent total request. This is similar in effect to using the Visual Totals features found in SAS OLAP clients. The benefit to using the Security Subset is that the exclusion of the secured members is handled by the server directly, improving the performance of the response.
As an example, consider the following scenario:
- A member-level permission is applied to your cube:
{[Dealers].[All Dealers], descendants([Dealers].[All Dealers].[Smith])}
- The following MDX query is submitted by a restricted user:
select measures on columns,
dealers.members on rows
from mddbcars
- The results returned depend on the SAS release and whether or not security subsets were enabled.
- If the cube was built using SAS 9.2 with the Security Subset enabled, these will be the results:
- If the cube was built using SAS 9.2 without the Security Subset enabled, the results will be the same as those seen in SAS 9.1:
Note that for both screen shots, the values for Smith are identical, but, in the case of 3a, the parent, "All Dealers" shows only the sales allowed by the security restriction.
Operating System and Release Information
SAS System | SAS OLAP Server | z/OS | 9.2 TS2M0 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | |
Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | |
Microsoft® Windows® for x64 | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | |
Microsoft Windows XP Professional | 9.2 TS2M0 | |
Windows Vista | 9.2 TS2M0 | |
64-bit Enabled AIX | 9.2 TS2M0 | |
64-bit Enabled HP-UX | 9.2 TS2M0 | |
64-bit Enabled Solaris | 9.2 TS2M0 | |
HP-UX IPF | 9.2 TS2M0 | |
Linux | 9.2 TS2M0 | |
Linux for x64 | 9.2 TS2M0 | |
OpenVMS on HP Integrity | 9.2 TS2M0 | |
Solaris for x64 | 9.2 TS2M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Usage Note |
Priority: | |
Topic: | System Administration ==> Security ==> Permissions Data Management ==> Data Sources ==> Cubes Query and Reporting ==> OLAP (Online Analytical Processing)
|
Date Modified: | 2010-03-04 15:24:01 |
Date Created: | 2010-02-16 13:15:49 |