Problem Note 20716: Performance of OLAP based reports might be slow when using hidden data
items
When creating a report in SAS Web Report Studio, the report might take a
long time to display. This is most likely to occur if the data is built
from an OLAP Cube with a large amount of data items. Even though some of
the data items have been moved to the Hidden function in the Table Data
Dialog Box, the performance will still be slow.
To circumvent the problem, instead of moving the data items to the
Hidden function, do not include them in the selected data items.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Web Report Studio | Solaris | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| Microsoft Windows 2000 Advanced Server | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| Microsoft Windows NT Workstation | 3.1 | 4.2 | 9.1 TS1M3 SP4 | |
| Microsoft Windows XP Professional | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| Microsoft Windows 2000 Server | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| Microsoft Windows 2000 Professional | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| 64-bit Enabled Solaris | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| Microsoft Windows 2000 Datacenter Server | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| HP-UX | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| 64-bit Enabled HP-UX | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| 64-bit Enabled AIX | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| AIX | 3.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 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 |
| Date Modified: | 2007-09-06 14:15:12 |
| Date Created: | 2007-08-01 12:51:53 |
