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

Exercise No. 16: Workout (apa)

This cube stores data about athletes doing a workout.

We have four dimensions with the following hierarchical structure:

Table A.E.55.1 - workout

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

1) "a monthly report for the exercises a certain athlete has done"

2) "all athletes who are assissted by a certain personal coach"

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

Solution

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

Exercises List