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

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

Exercises List