• Print |
• E-mail  |
• Bookmark

A new option is available in the SAS 9 OLAP Server. This option may
provide improved performance in certain situations when OLAP query
results contain many empty cells. The information that follows explains
how to use 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 OLAPCACHEEMPTYSQ as the variable name
   enter 1 as the value to enable the option
         (0 will disable the option)
   click OK

2. On UNIX-based systems:

    ksh: export OLAPCACHEEMPTYSQ=1

    csh: setenv OLAPCACHEEMPTYSQ 1

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.


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#014160

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#014160

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 :