Studierende stehen vor dem LC und blicken lächelnd einer Kollegin mit einer Mappe in der Hand nach.

Exercise No. 31: Shipments (apa)

This cube stores data about batches beeing shipped to certain destinations via different modes of transportation. A cost center group is responsible for each shipment.

We have five dimensions with the following hierarchical structure:

Table A.E.68.1 - Shipments

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

Please select the corresponding cells in the APA and choose the cubes to materialize, then highlight the derivatives of those cubes.

Solution

Figure A.E.68.1 - The resulting APA with the redundany free-set highlighted

Size of the redunancy-free set (including the base cube): 108

Required cubes, the materialization decision and derivatives The blue cell represent the cube covering requirement 1 ("a monthly report by batch and destination country, irrespective of the transportation mode and the responsible cost center group") and the green cell represents requirement 2 ("an annual report for each cost center group, including the mode of transportation, independent of batch and destination").

Materializing cube v = (R_*, M_*, D_cty, B_ba, T_m) (blue cell "D_cty") does not cover requirement 2, so we will have to materialize the second cube u = (R_ccg, M_mt, D_*, B_*, T_y) (green cell "T_y").

Figure A.E.68.2 - Derivatives of cube v = (R_*, M_*, D_cty, B_ba, T_m)

Figure A.E.68.3 - Derivatives of cube u = (R_ccg, M_mt, D_*, B_*, T_y)

This exercise is part of a case study: dfm - apa - log

Exercises List