When attempting to build a SAS OLAP cube, your PROC OLAP code may fail
to successfully complete with no cube being created. Messages similar to
the following may be written to the log, where the actual memory amounts
in bytes will vary:

   NOTE: The initial memory limit for classification tables was 281335K
         bytes.
   Actual memory acquired was 294720K bytes.

   ERROR: Cube "BCP2" cannot be created.
   NOTE: The SAS System stopped processing this step because of errors.

This problem was encountered when trying to build a cube from a star
schema where the dimension table contained millions of records and each
record of a dimension table translates into a distinct key. This
resulted in an out of memory condition even though no notes to that
affect were surfaced in the SAS log.

It seems the problem is a result of formatted key values being passed to
the summary object, which is using much more memory than is necessary to
store the formatted key values. This problem can occur regardless of
what the SAS system options MEMSIZE, REALMEMSIZE, or SUMSIZE were set
to. It is recommended that your SAS OLAP Server have a minimum MEMSIZE
setting of 512M, and should be set to the amount of available memory on
the machine. The REALMEMSIZE option should be set to 75-80% of MEMSIZE.


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

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

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 :