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

Exercise No. 18: Cost Center Accounting (log)

This is an example about cost center accounting. Costs are assigned to a cost center, a cost element and a fiscal/controlling period.

We have three dimensions with the following hierarchical structure (the first dimension features a parallel hierarchy at level 1):

Table L.E.18.1 - Cost center accounting

"Amount" is the only key figure, representing the balance of the corresponding cost center. Each cost center has an additional attribute "C_cc_resp", the person that is responsible for the cost center.

Please draw the Classic Star Schema for this example, create the dimension tables "cost element" and "cost center", then build the Fact Constellation Schema.

Also draw the example's dimension tables partitioned and normalized.

Solution

Exercises List