Problem Note 39209: Use of parent totals might require more memory than the use of visual totals in OLAP-based reports
In many cases, the use of the parent totals results in faster response time for an OLAP query. However, the request might require additional memory. Additionally, if the set of members on the totaled axis is high due to many crossjoins or a few large cardinality levels, the performance of the parent totals will be noticeably slower than that of the visual totals.
Operating System and Release Information
| SAS System | SAS OLAP Server | z/OS | 9.2 TS2M2 | 9.4 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M2 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M2 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M2 | 9.4 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M2 | 9.4 TS1M0 |
| Microsoft® Windows® for x64 | 9.2 TS2M2 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M2 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M2 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M2 | 9.4 TS1M0 |
| Microsoft Windows Server 2008 | 9.2 TS2M2 | 9.4 TS1M0 |
| Microsoft Windows XP Professional | 9.2 TS2M2 | 9.4 TS1M0 |
| Windows 7 Enterprise 32 bit | 9.2 TS2M2 | |
| Windows 7 Enterprise x64 | 9.2 TS2M2 | |
| Windows 7 Home Premium 32 bit | 9.2 TS2M2 | |
| Windows 7 Home Premium x64 | 9.2 TS2M2 | |
| Windows 7 Professional 32 bit | 9.2 TS2M2 | |
| Windows 7 Professional x64 | 9.2 TS2M2 | |
| Windows 7 Ultimate 32 bit | 9.2 TS2M2 | |
| Windows 7 Ultimate x64 | 9.2 TS2M2 | |
| Windows Vista | 9.2 TS2M2 | 9.4 TS1M0 |
| 64-bit Enabled AIX | 9.2 TS2M2 | 9.4 TS1M0 |
| 64-bit Enabled HP-UX | 9.2 TS2M2 | 9.4 TS1M0 |
| 64-bit Enabled Solaris | 9.2 TS2M2 | 9.4 TS1M0 |
| HP-UX IPF | 9.2 TS2M2 | 9.4 TS1M0 |
| Linux | 9.2 TS2M2 | 9.4 TS1M0 |
| Linux for x64 | 9.2 TS2M2 | 9.4 TS1M0 |
| OpenVMS on HP Integrity | 9.2 TS2M2 | 9.4 TS1M0 |
| Solaris for x64 | 9.2 TS2M2 | 9.4 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-04-02 15:10:38 |
| Date Created: | 2010-03-30 10:25:19 |
