Please build the Aggregation Path Array and assume the following end-user requirement:

1) "a quarterly report for each combination of captain and airplane."

Select the corresponding cells in the APA and choose a cube to materialize, then highlight the derivatives of this cube.

Figure A.E.1.1 - The resulting APA with the redundancy free-set highlighted

Size of the redundancy-free set (including the base cube): 72

Required cubes, the materialization decision and derivatives

The blue area represents the end-user requirement 1("a quarterly report for each combination of captain and airplane."), it is met by materializing cube v = (C_c, A_a,AI_*, T_q) (dark blue cell "T_q"). The area to the right of the black line includes all derivatives of v.

Figure A.E.1.2 - Derivatives of cube v = (C_c, A_a,AI_*, T_q)