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

Exercise No. 26: Project Management (log)

This cube stores data about work packages of a project.

We have four dimensions with the following hierarchical structure:

Table L.E.53.1 - project management

There are two key figures in this example, "costs" and "number of work packages". Each project has an additional attribute "P_co_phone", the phone number of the customer.

Please draw the Classic Star and the Fact Constellation Schema.

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