Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

How to Use Aggregations on OLAP Cubes


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.

Process

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.
Under the node of each cube, you will find the Aggregations node:


When right clicking the node you will get a menu called Read Cube Aggregations:


When selecting the Read Cube Aggregation the JDM 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:


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 there are a number of Microsoft article, including the one here: Aggregations and Aggregation Design

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments