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

Exercise No. 59: Real Estate II (apa)

This cube stores data of an information system of a real estate company.

We have six dimensions with the following hierarchical structure:

Table A.E.63.1 - real estate

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

1) "a roll up by the time dimension starting at months for each combination of agents and real estate"

2) "a yearly report of the branch independent of all other dimensions"

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