Anaplan XL's data access behavior can be configured using XML files. If you change these, you will need to restart Excel or run IISRESET on the web server.

It isn't recommended that these XML files be changed without advice from Anaplan XL Support.

File locations

These files can be found in:

  • Excel Edition - Install folder for example C:\Program Files (x86)\Anaplan\AnaplanXL Reporting
  • Web Edition - Install folder\bin, for example, c:\Inetpub\wwwroot\Anaplan XL Web\bin

You can control when the cache is cleared and which metadata to cache.

The cache clearing can be set to occur daily, at a given time, or at a specified interval—every X minutes.

The cache settings can be configured per cube and schema if a specific setting is found that'll override a general one. For example, a specific schema setting will override that for * schemas.

Caches can set the policy type and size.

Policy types are:

  • PublicChecked - Shared between users, but the cube will be queried on the first request to check if the user has read permission for the object.
  • PublicUnchecked - Shared between users. The cube will be queried to get the metadata on the first request, which is then shared between subsequent users.
  • Private - Cache is per user and cube is queried for metadata the first time each user requests it.
  • PrivateBySession - The cache is per user session. The cube will be queried for different connections from the same user.
  • Off - Cache is disabled for this schema.
  • Cache policy sizes can be:
    • 0 - Don't cache
    • -1 - Cache all objects
    • N - any positive number; maximum cache size before objects are removed. N is the count of objects stored.