Usage Note 45001: File sizes of SAS® OLAP cubes might be significantly larger than Microsoft® SQL Server® Analysis Services cubes generated from the same data.
Users of SAS® Activity-Based Management might notice significant increase in the disk space consumed by OLAP cube data files. The issue might occur for solutions that have moved from Microsoft® SQL Server® Analysis Services OLAP server to use SAS OLAP. The increase in disk space consumption is due to inherent differences in the way the two OLAP server store member data and the degree of increase is highly data-dependent. The difference can range from a minor increment to an order of magnitude.
Users planning on reconfiguring their SAS Activity-Based Management servers to use SAS OLAP should make arrangements to allow for the allocation of additional disk space if needed.
It is also possible to reduce the impact of such a configuration change by adding options such as COMPACT_NWAY and NONUPDATEABLE to the SAS Activity-Based Management cube configuration for inclusion in the PROC OLAP statement. Refer to the SAS OLAP Server User's Guide for more information about options for the OLAP procedure and their effects. After making any changes to the cube configuration, it is necessary to re-generate the cube for them to take effect.
Operating System and Release Information
SAS System | SAS Activity-Based Management | Microsoft® Windows® for x64 | 7.1 | | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Datacenter Edition | 7.1 | | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Enterprise Edition | 7.1 | | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Standard Edition | 7.1 | | 9.2 TS2M3 | |
Microsoft Windows Server 2003 for x64 | 7.1 | | 9.2 TS2M3 | |
Microsoft Windows Server 2008 | 7.1 | | 9.2 TS2M3 | |
Microsoft Windows Server 2008 for x64 | 7.1 | | 9.2 TS2M3 | |
Microsoft Windows XP Professional | 7.1 | | 9.2 TS2M3 | |
Windows 7 Enterprise 32 bit | 7.1 | | 9.2 TS2M3 | |
Windows 7 Enterprise x64 | 7.1 | | 9.2 TS2M3 | |
Windows 7 Home Premium 32 bit | 7.1 | | 9.2 TS2M3 | |
Windows 7 Home Premium x64 | 7.1 | | 9.2 TS2M3 | |
Windows 7 Professional 32 bit | 7.1 | | 9.2 TS2M3 | |
Windows 7 Professional x64 | 7.1 | | 9.2 TS2M3 | |
Windows 7 Ultimate 32 bit | 7.1 | | 9.2 TS2M3 | |
Windows 7 Ultimate x64 | 7.1 | | 9.2 TS2M3 | |
Windows Vista | 7.1 | | 9.2 TS2M3 | |
Windows Vista for x64 | 7.1 | | 9.2 TS2M3 | |
64-bit Enabled AIX | 7.1 | | 9.2 TS2M3 | |
64-bit Enabled Solaris | 7.1 | | 9.2 TS2M3 | |
Linux for x64 | 7.1 | | 9.2 TS2M3 | |
Solaris for x64 | 7.1 | | 9.2 TS2M3 | |
*
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.
Users who migrate from SQL Server® Analysis Services as the OLAP server for SAS® Activity-Based Management to SAS® OLAP might find that the disk space required for the storage of cube files increases significantly.
Date Modified: | 2011-12-05 14:24:06 |
Date Created: | 2011-12-01 15:20:04 |