Filling the OLAP Cache 

Use

The distribution type Fill OLAP Cache allows you to precalculate queries and to fill the OLAP cache with the generated data.

If the users call Web Applications, queries, reports or workbooks that are based on this data, the access time is significantly reduced and the workload on the application server is considerably less.

Since the functions of the OLAP cache were designed so that the user does not have to wait any longer than normal when evaluating a query, it is not possible to guarantee the OLAP cache will be completely filled.

It is possible that the expected entry for a query is not stored in the cache. The query must then be completely reevaluated with access to the InfoProvider. This situation is intensified when several attempts are made to access the query at the same time.

Prerequisites

You have chosen the distribution type Fill OLAP Cache. The output format is OLAP Cache Content.

Features

You make the settings for filling the OLAP cache on the following tab pages:

User/Language

On the User/Language tab page you can determine for the background processing of the broadcast setting the language, authorizations and user-specific settings with which the scheduled document is to be generated.

For more information, see User/Language.

General Precalculation

You make various settings here relating to, for example, variables or exceptions.

For more information, see General Settings During Precalculation and the Creation of Links.

Filter Navigation

On the Filter Navigation tab page you can specify characteristics or a control query so that the system precalculates several documents with different filter settings from the same query.

For more information, see Filter Navigation.