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

Exercise No. 7: Car Sales (apa)

As the result of DFM Case "car sale" this cube stores data about a car sale.

We have three dimensions with the following hierarchical structure:

Table A.E.23.1 - car sale

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

1) "a weekly report on a car type, independent of the car dealer"

2) "a monthly report on a sales area, irrespective of the car"

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