Extended Properties

Cache Partitioning

The OLAP Server saves calculated values in the cache to retrieve them quickly instead of recalculating them. Changed values and dependent cells are invalidated (deleted from the cache) according to the dependencies in the cache partitions. Due to these saved dependencies between cache partitions, it is not necessary to delete the whole cube cache, but only dependent partitions. This is also valid for dependencies between different cubes.

One partition is created for each element of the dimension. The maximum number of elements allowed in the dimension is 256. If the dimension contains more than 256 elements, partitioning is disabled and a message is written into the AleaPr.txt log file.

Example:

To indicate the dimension "YEARS" as to be partitioned, enter this XML information into the Extended Properties dialog box:

<Alea:Properties xmlns:Alea="http://www.misag.com">
  <Alea:CachePartitionDimension Name="YEARS"/>
 </Alea:Properties>