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

Exercise No. 34: Writing Articles (apa)

As the result of DFM Case "writing articles" this cube stores data about an author writing articles for a newspaper.

We have five dimensions with the following hierarchical structure:

Table A.E.7.1 - Writing articles

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

1) "a monthly report for each subject group irrespective of the author, the lector and the newspaper"

2) "a roll up by the time dimension starting at years for each author and article subject group independent of the newspaper and lector"

3) "an annual report for each lector, including the newspaper type, irrespective of the author and the article"

Select the corresponding cells in the APA and choose the cubes to materialize, then highlight the derivatives of those cubes.

Solution

This exercise is part of a case study: dfm - apa - log

Exercises List