Arrange your hierarchies

Pivot table dimensions can be viewed as forming a hierarchy in the report structure. Arrange the hierarchies so that the values are triggered at the desired point in the data stream.

In order to minimize the volume of the data stream, the HIERACHIES can be shipped sparsely, in the sense that not all hierarchy values need to be shipped for every row. Comparing the hierarchy values of two consecutive rows from right to left starting with the innermost dimension, any value can be omitted that is the same in both rows until reaching the first dissimilar column.

This example shows two equivalent pivot tables. The first table uses a flat representation while the second ships the values using a more space efficient method. It ships the value for “userid” only on changes of “userid” by placing the value in the corresponding trigger. The value remains the same for all orders of that customer. The same is done for “orderid” which changes its value for every order but remains the same for all items within the order. The arrows in the diagrams indicates the location of the hierarchies.

Figure: Flat shipping of dimension values


This figure shows an example of a Report Structure where the dimensions userid and orderid are both located as children of the OnEveryRow trigger.

Figure: Optimized shipping of dimension values


This figure shows an example of a Report Structure where the dimensions are arranged such that the userid Dimension is under the Group userid trigger and the orderid Dimension is under the Group orderid trigger.