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.

For additional information about the SECURITY_SUBSET feature, see SAS Note 38756

Operating System and Release Information