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

Exercise No. 42: Betting (apa)

This cube stores data about customers placing bets in betting office.

We have five dimensions with the following hierarchical structure:

Table A.E.52.1 - betting

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

1) "a monthly report for each combination of type of event, customer and branch"

2) "a roll-up by the time dimension of type of event and city starting with months"

3) "a yearly report of customer"

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