2005495 - How do I configure the DataCacheManager in SAP InfiniteInsight?

During the execution of a model, an error is thrown relating to the DataCacheManager size limit being reached.  It may be necessary to adjust the cache size.

The default values are:

########## DATA CACHE MANAGER PARAMETERS ##########

# Designed for being inserted by general KXEN Configuration files
# like KJWizard.cfg or KxShell.cfg.
# The parameter values represent the default configuration of the Data Cache
# Uncomment any option you want to change.

#### General Options ####

#DataCacheManager.Options.Enable=true
#DataCacheManager.Options.DropSpaces=true
#DataCacheManager.Options.DisableSplit=false
#DataCacheManager.Options.MaxProcSize=0
#### Cache Levels configuration ####

#DataCacheManager.CacheL1.StoreClass=Kxen.CacheMemoryStore
#DataCacheManager.CacheL1.StoreOpen=RootMemoryStore
#DataCacheManager.CacheL1.SizeLimit=500

#DataCacheManager.CacheL2.StoreClass=Kxen.FileStore
#DataCacheManager.CacheL2.StoreOpen=$KXTEMPDIR
#DataCacheManager.CacheL2.SizeLimit=2000

#### Cache Strategy ####

#DataCacheManager.StoreClassToCache.1=Kxen.ODBCStore

#DataCacheManager.StoreOpenToNotCache.1=MyDatabaseName

"SAP InfiniteInsight", infiniteinsite, BI-RA-PA-II , KBA , BI-RA-PA-II , SAP InfiniteInsight , How To