A new option is available in the SAS 9 OLAP Server. This option can be
used to control the size of the server's subquery cache. Each user
session will use memory up to the specified limit to cache subquery
requests. The information that follows explains how to use this option.

Beginning in SAS 9.1.3 Service Pack 3, this option can be set in the SAS
Management Console. To locate this option follow the steps below.
"SASMain" refers to the application server name that contains the OLAP
Server component:

  1. Expand Server Manager -> SASMain -> SASMain - Logical OLAP Server.
  2. Right-click on SASMain - OLAP Server and select Properties.
  3. Select the Options tab and click Advanced Options.
  4. Select the Cache tab.
  5. To enable the cache, check "Cache the empty subquery result sets".
  6. Set the memory according to the information below.
  7. Click OK to exit the dialogs and save the settings.
  8. Restart the OLAP Server to pick up the changes.


Prior to SAS 9.1.3 Service Pack 3, the following information can be
used to set this option.

1. On Microsoft Windows:

   go to: Start-> Settings-> Control Panel
   double-click on System
   click on the Advanced Tab
   click Environment Variables
   under System Variables, click New
   enter OLAPSQCACHESIZE as the variable name
   enter the size in megabytes for the cache. See notes
         below on appropriate settings.
   click OK

2. On UNIX-based systems:

    ksh: export OLAPSQCACHESIZE=###

    csh: setenv OLAPSQCACHESIZE ###

### is the value in megabytes. See notes below on appropriate settings.

For any environment, the OLAP Server will need to be restarted to pick
up the changes to the environment variable.

The precedence of options for the OLAP server is as follows:

1. SAS will check for and apply any environment variables.

2. If a logical server definition is specified in the SAS System
Options, then SAS will access the specified metadata server and apply
all values associated with that logical server definition. NOTE: These
values from the OMR override any values set in step 1 above.

The following are settings for the option (in Megabytes):
  0 - disable option, causes original cache behavior using 1 MB
  1 <= x <= 50 - enable the option with the specified number of
      Megabytes


A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#014942

For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#014942

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :