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

Exercise No. 33: Bus Tour (apa)

As the result of DFM Case "bus tour" this cube stores data about a bus tour.

We have five dimensions with the following hierarchical structure:

Table A.E.5.1 - Bus tour

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

1) "a roll up by the time dimension starting at years for each bus type independent of the customer, the country the tour is going to and the employee"

2) "a monthly report on salary levels independent of the customer, the country and the bus"

3) "a complete drill-down by the time dimension down to month for each employee on a bus type, irrespective of the customer and the country"

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