Problem Note 41175: SECURITY_SUBSET not honored for totals after import of cube metadata
If you import a SAS package file containing OLAP cube metadata where there is member-level security defined to one or more dimensions in the exported cube, the SECURITY_SUBSET setting might not be honored. If the original cube does not include secured members in presummarized computations, where the SECURITY_SUBSET=YES option is enabled, this setting might not correctly be applied to the cube's imported metadata. If this setting is not applied, then secured members might be included in the parent totals for secured dimensions. This behavior can occur when cube metadata is imported but the underlying physical cube files are not recreated.
You can circumvent this issue by either of the two methods below:
-
After the import, recreate your OLAP cube to correctly update the metadata.
-
Submit the following PROC OLAP code with the UPDATE_DISPLAY_NAMES option to update the cube's metadata without rebuilding the cube:
PROC OLAP CUBE="/Shared Data/CubeName" Description="Cube Description"
UPDATE_DISPLAY_NAMES ;
metasvr olap_schema='SASApp - OLAP Schema' repository='Foundation'
host='hostname' port=8561 userid="userid" pw="password";
run;
|
Click the Hot Fix tab in this note to access the hot fix for this issue.
The following SAS Notes provide information on the SECURITY_SUBSET setting for an OLAP cube:
For more information and examples of using the SECURITY_SUBSET= option, refer to the
SAS 9.2 OLAP Server MDX Guide.
Operating System and Release Information
| SAS System | SAS OLAP Server | Linux for x64 | 9.2 TS2M0 | 9.3 TS1M0 |
| Linux | 9.2 TS2M0 | 9.3 TS1M0 |
| HP-UX IPF | 9.2 TS2M0 | 9.3 TS1M0 |
| 64-bit Enabled Solaris | 9.2 TS2M0 | 9.3 TS1M0 |
| 64-bit Enabled HP-UX | 9.2 TS2M0 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 9.2 TS2M0 | 9.3 TS1M0 |
| Windows Vista for x64 | 9.2 TS2M0 | 9.3 TS1M0 |
| Windows Vista | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft® Windows® for x64 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | 9.3 TS1M0 |
| z/OS | 9.2 TS2M0 | 9.3 TS1M0 |
| OpenVMS on HP Integrity | 9.2 TS2M0 | 9.3 TS1M0 |
| Solaris for x64 | 9.2 TS2M0 | 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.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Query and Reporting ==> OLAP (Online Analytical Processing)
|
| Date Modified: | 2010-10-14 10:37:30 |
| Date Created: | 2010-10-08 14:02:09 |
