Show TOC

Filling the MDX CacheLocate this document in the navigation structure

Use

The Fill MDX Cache distribution typeallows you to precalculate BEx queries in the background, which can then be used as data providers for Crystal Reports. This function is a device used to improve system performance when executing Crystal Reports.

Prerequisites

You have created a broadcast setting and have chosen Fill MDX Cache as the distribution type. The output format is MDX Result Set.

More information:Creating Broadcast Settings

Procedure

Specifying Language and User-Specific Settings

On the User/Language tab page, you can specify, for the background processing of the broadcast setting, which language, authorizations, and user-specific settings are to be used to generate the scheduled document.

More information:Specifying Language and User-Specific Settings

Specifying the Variable Assignment

On the General Precalculation tab page, you make settings for the variable assignment.

Note

This tab page only appears when the query contains variables.

More information:Making General Settings for Precalculation and the Creation of Links

Specifying Filter Navigation

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

More information:Specifying Filter Navigation