Cube Aggregations

Overview

Using aggregations can significantly improve query response time in certain circumstances by optimizing data in the cubes based on how users frequently access the data. This article will explain how to import aggregations into the Jet Data Manager (JDM).

The purpose of this feature is not to be able to design aggregation in the JDM. What the feature supports is to read and store aggregation designed in an aggregation design tool. The JDM reads the definition of the aggregation and stores it in the project. During deployment of the cube, the aggregation will be applied to the cube.

Process

1. Under the node of each cube, you will find the Aggregations node.

   

2. Right-click and select Read Cube Aggregations.

   

3. The Jet Data Manager will read the aggregation on the cube and report the number of aggregations that were read.

   The aggregations will be listed under the Aggregations node.

   

4. The aggregations are stored in an XML structure and can be edited in a simple text editor in the JDM.

   Right-click the aggregation you want edit and select Edit Cube Aggregation.

   

   

   For more information about aggregations and aggregation design, see Aggregations and Aggregation Design.