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

Exercise No. 28: Memorial Hospital (apa)

This cube stores data about patients being treated in the Memorial Hospital.

We have four dimensions with the following hierarchical structure:

Table A.E.57.1 - Memorial Hospital

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

1) "a roll-up of the time dimension starting at weeks for each department independent of all other dimensions"

2) "a monthly report for each ward"

3) "a complete drill-down by the time dimension down to day for each combination of patient and nurse"

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

Solution

Exercises List