Table A.E.52.1 - betting

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

1) "a monthly report for each combination of type of event, customer and branch"

2) "a roll-up by the time dimension of type of event and city starting with months"

3) "a yearly report of customer"

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

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

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

Required cubes, the materialization decision and derivatives

The blue area represents the end-user requirement 1 ("a monthly report for each combination of type of event, customer and branch"), the end-user requirement 2 ("a roll-up by the time dimension of type of event and city starting with months") and the end-user requirement 3 ("a yearly report of customer").

Materializing cube v = (C_cu, M_*, E_ty, B_br, T_m) (dark blue cell "T_m", representing end-user requirement 1), cube w = (C_*, M_*, E_ty, B_ci, T_m) (dark green cell "T_m", representing end-user requirement 2) and cube x = (C_cu, M_*, E_*, B_*, T_y) (red cell "T_y", representing end-user requirement 3) offer us the following sets of derivatives.

Figure A.E.52.2 - Derivatives of cube v = (C_cu, M_*, E_ty, B_br, T_m)

Figure A.E.52.3 - Derivatives of cube w = (C_*, M_*, E_ty, B_ci, T_m)

Figure A.E.52.4 - Derivatives of cube x = (C_cu, M_*, E_*, B_*, T_y)

Figures A.E.52.2 to A.E.52.4 show that end-user requirements 2 and 3 are covered by the derivatives of the vector v (end-user requirement 1). To meet all end-user requirements we will only have to materialize cube v.