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

Exercise No. 29: State University Enrollment (apa)

This cube stores data of the State University information system.

We have four dimensions with the following hierarchical structure:

Table A.E.60.1 - State University Enrollment

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

1) "a report on rooms occupied in a term"

2) "a report of each combination of student and course in a term"

3) "a report of each combination of course and school in a term regardless of student enrollment"

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