MicroStrategy ONE

Enabling or Disabling Element Caching

When the MicroStrategy system is installed for the first time, the element caching is enabled by default. You can disable it for an entire project, for a Developer client, or for a specific attribute in the project's schema. The data source cache setting DssCacheSettingElementMaxMemoryConsumption controls the total amount of memory used by the element server cache. Setting this value to zero completely disables the element cache.

In situations where the data warehouse is loaded more that once a day, it may be desirable to disable element caching.

To Disable Element Caching for a Project

In the Project Configuration Editor, in the Caching: Auxiliary Caches (Elements) category, under Server, set the Maximum RAM usage (KBytes) to 0 (zero).

To Disable Element Caching for Developer

In the Project Source Manager, select the Memory tab, set the Maximum RAM usage (KBytes) to 0 (zero).

You might want to perform this operation if you always want to use the caches on Intelligence Server. This is because when element caches are purged, only the ones on Intelligence Server are eliminated automatically while the ones in Developer remain intact. Caches are generally purged because there are frequent changes in the data warehouse that make the caches invalid.

To Disable Element Caching for an Attribute

  1. In Developer, right-click the attribute and select Edit.
  2. On the Display tab, clear the Enable element caching check box.