Problem Note 50095: Including hidden data items in a SAS® Web Report Studio report can negatively impact performance
 |  |  |  |  |
When selecting a data source for a report, you should choose only those data items that you plan to use in the report. Any data items that you do not use are placed in the hidden role. Because hidden data items are still considered in the query, including unnecessary data items can negatively impact performance.
For example, suppose that you have an information map that contains 20 data items. If you plan to only use eight of those data items in your report, then select only those data items in the Select Data dialog box.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Although the hot fix improves performance when your report includes hidden data items, it does not completely prevent performance problems. Depending on the number of hidden data items, you can still experience performance problems. As a best practice, include only those data items that you need in your report objects.
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.31 | 4.31_M2 | 9.3 TS1M2 | 9.3 TS1M2 |
| 64-bit Enabled AIX | 4.31 | 4.31_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| 64-bit Enabled Solaris | 4.31 | 4.31_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| HP-UX IPF | 4.31 | 4.31_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Linux for x64 | 4.31 | 4.31_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Solaris for x64 | 4.31 | 4.31_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
A fix for this issue for SAS Web Report Studio 4.31_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I84.html#50095A fix for this issue for SAS Web Report Viewer 4.31_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I85.html#50095| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2013-06-19 14:18:21 |
| Date Created: | 2013-06-03 10:53:41 |