Table A.E.63.1 - real estate

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

1) "a roll up by the time dimension starting at months for each combination of agents and real estate"

2) "a yearly report of the branch independent of all other dimensions"

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

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

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

Required cubes, the materialization decision and derivatives

The blue area represents the end-user requirement 1 ("a roll up by the time dimension starting at months for each combination of agents and real estate") and the end-user requirement 2 ("a yearly report of the branch independent of all other dimensions").

Materializing cube v = (O_*, B_*, L_*, R_re, A_ag, T_m) (dark blue cell "T_m", representing end-user requirement 1) and cube w = (O_*, B_*, L_*, R_*, A_br, T_y) (dark green cell "T_y", representing end-user requirement 2) offer us the following sets of derivatives.

Figure A.E.63.2 - Derivatives of cube v = (O_*, B_*, L_*, R_re, A_ag, T_m)

Figure A.E.63.3 - Derivatives of cube w = (O_*, B_*, L_*, R_*, A_br, T_y)

Figures A.E.63.2 to A.E.63.3 show that end-user requirement 2 is covered by the derivatives of vector w (end-user requirement 1). To meet all end-user requirements we will only have to materialize cube v.