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

Exercise No. 5: Delivery to a Plant (apa)

The following cube stores data about deliveries by certain suppliers to certain plants.

We have three dimensions with the following hierarchical structure:

Table A.E.15.1 - The teaching case simplified

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

1) "a roll.up by the time dimension starting at quarters for each supplier, irrespective of the plant the goods are delivered to."

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

Solution

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

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

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 quarters for each supplier, irrespective of the plant the goods are delivered to"), it is met by materializing cube v = (P_*, S_su, T_q) (dark blue cell "T_q"). The area to the right of the black line includes all derivatives of v.

Figure A.E.15.2 - Derivatives of cube v = (P_*, S_su, T_q)

Exercises List