Usage Note 33736: ReadMetadata and WriteMetadata permissions required for all SAS® OLAP cube objects in order to edit or update a cube
In SAS® 9.2, in order to update a SAS OLAP cube, users must have ReadMetadata and WriteMetadata permissions granted for all metadata objects that are associated with a cube, including dimensions, levels, hierarchies, and measures. For example, users who are denied WriteMetadata permission to a measure on a cube will not be able to delete that cube. In addition, in SAS® OLAP Cube Studio, the Edit Cube Structure and Build Physical Cube menu options will not be available to users who do not have full access to all of a cube's metadata objects.
If a user is not able to rebuild an OLAP cube in SAS 9.2, then review the metadata permissions that are defined for the cube in order to verify that the user has been granted ReadMetadata and WriteMetadata permissions for all of the cube's objects.
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 | |
| SAS System | SAS OLAP Cube Studio | Microsoft® Windows® for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows XP Professional | 4.2 | | 9.2 TS2M0 | |
| Windows Vista | 4.2 | | 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: | high |
| Topic: | Query and Reporting ==> OLAP (Online Analytical Processing) Data Management ==> Data Sources ==> Cubes
|
| Date Modified: | 2009-03-06 16:34:11 |
| Date Created: | 2008-10-22 11:46:11 |