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

Exercise No. 2: Banking (apa)

This cube stores data about a customer asking for a loan at a bank.

We have three dimensions with the following hierarchical structure:

Table A.E.2.1 - banking

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 customer, irrespective of the branch the customer goes to."

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