Usage Note 45792: The SECURITY_SUBSET option is lost when performing an incremental cube update when using the OUTCUBE option
If an incremental update is performed using the OUTCUBE option on a cube that has SECURITY_SUBSET=YES specified, then the SECURITY_SUBSET option is lost on the new generated cube.
Note: The OUTCUBE= option is associated with the Generate New Cube incremental update method.
Figure 1 shows that the Include secured member values in presummarized computations option is not selected on the original cube. When this option is not selected, the SECURITY_SUBSET option is equal to YES.
Figure 1. Include secured member values in presummarized computations is not selected on the original cube.
Figure 2 shows that the Include secured member values in presummarized computations option is selected on the new generated cube after performing an incremental update using the OUTCUBE option. When this option is selected, the SECURITY_SUBSET option is equal to NO.
Figure 2. Include secured member values in presummarized computations is selected on the new generated cube.
The following code will reset the SECURITY_SUBSET=YES on a cube after performing the incremental update using the OUTCUBE option.
PROC OLAP
CUBE = “cubename"
UPDATE_DISPLAY_NAMES
SECURITY_SUBSET = YES;
METASVR
HOST = "<server name>"
PORT = 8561
OLAP_SCHEMA = "SASApp - OLAP Schema"
UserID='xxxx'
PW='xxxx';
RUN;
For additional information about the SECURITY_SUBSET feature, see SAS Note 38756
Operating System and Release Information
| SAS System | SAS OLAP Server | z/OS | 9.1 TS1M2 | 9.3 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M2 | 9.3 TS1M0 |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M2 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M2 | |
| Microsoft Windows 2000 Server | 9.1 TS1M2 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M2 | |
| Microsoft Windows NT Workstation | 9.1 TS1M2 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M2 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 9.1 TS1M2 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 9.1 TS1M2 | 9.3 TS1M0 |
| 64-bit Enabled HP-UX | 9.1 TS1M2 | 9.3 TS1M0 |
| 64-bit Enabled Solaris | 9.1 TS1M2 | 9.3 TS1M0 |
| HP-UX IPF | 9.1 TS1M2 | 9.3 TS1M0 |
| Linux | 9.1 TS1M2 | 9.3 TS1M0 |
| OpenVMS Alpha | 9.1 TS1M2 | 9.3 TS1M0 |
| Tru64 UNIX | 9.1 TS1M2 | 9.3 TS1M0 |
*
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.
| Date Modified: | 2012-03-01 16:56:01 |
| Date Created: | 2012-02-23 16:11:43 |
