Show TOC

Metadata CacheLocate this document in the navigation structure

The metadata cache behavior is different, depending on the types of connections.

Metadata Cache for Local and SAP BusinessObjects Enterprise Connections

Applies to: Local and SAP BusinessObjects Enterprise connections.

The metadata cache feature is not activated by default, meaning that the dimensions and members are loaded each time you connect to a data source.

You can activate the cache, meaning that the metadata is copied locally and not loaded each time you connect to a data source. Using the cache enables you to improve the connection time. To activate the cache, select Start of the navigation path EPM Next navigation step User Options End of the navigation path, then select the Activate Metadata Cache option.

You can clear the metadata cache. When the cache is cleared, the structure of the data source you are connected to is synchronized with the structure copied locally; which means that the members of dimensions that have been added, modified or deleted in the data source are loaded.
  • You can define the frequency at which the cache is automatically cleared. Select Start of the navigation path EPM Next navigation step User Options End of the navigation path, then select the Clear Metadata Cache Frequency option and enter a number in the field. If you enter 1, the cache is cleared once a day.
  • You can clear the cache whenever you want. Select Start of the navigation path EPM Next navigation step More Next navigation step Clear Metadata Cache End of the navigation path or click the Clear Metadata Cache button in the Edit Connection and Create Connection dialog boxes, when editing and creating a connection.
Metadata Cache for Planning and Consolidation Connections

Applies to: Planning and Consolidation connections.

The metadata cache feature is always activated for Planning and Consolidation connections. Each time you connect to a data source, the structure of the data source you are connected to is synchronized with the structure copied locally.

You can clear the metadata cache. When the cache is cleared, all the local structure files are deleted and all the files of the structure of the data source are loaded locally. To do so, select Start of the navigation path EPM Next navigation step More Next navigation step Clear Metadata Cache End of the navigation path.