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

Exercise No. 32: Haircut (apa)

This cube stores data of an information system of a hair dressing salon.

We have four dimensions with the following hierarchical structure (the dimension "Stylist" features a parallel hierarchy at level 1):

Table A.E.69.1 - haircut

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

1) "a roll-up of the time dimension starting at months for each combination of branch and sex of the customer"

2) "a daily report for each stylist"

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