Problem Note 38612: Poor performance when moving data items in an OLAP-based SAS® Web Report Studio report
 |  |  |  |
In some cases, after applying a filter to your data, you might see slower than normal performance when moving data items within a crosstabulation table. This delay is likely caused by a new SAS® 9.2 feature that is making extra calls to internal methods called FILTERED TOTAL ADD and FILTERED TOTAL REMOVE.
If you are experiencing slow performance when moving data items, enable the SAS® OLAP Server's journal file with the option Print input MDX statement as described in SAS Note 38429. If the journal includes many instances of FILTERED TOTAL ADD statements or FILTERED TOTAL REMOVE statements for a single session, then you might be encountering this problem.
Removing the filter is the only workaround for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | Microsoft® Windows® for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| HP-UX IPF | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Linux for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Solaris for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> Cubes Query and Reporting ==> Interactive Querying Query and Reporting ==> OLAP (Online Analytical Processing) |
| Date Modified: | 2010-02-08 11:51:10 |
| Date Created: | 2010-02-04 12:41:20 |