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

Exercise No. 10: Cost Center (log)

Continuing APA case "Cost Center" we will now build the logical model.

We have four dimensions with the following hierarchical structure:

Table L.E.4.1 - Cost center

"Costs" is the only key figure in this example. Each building project has an additional attribute "B_bp_des", the project's description, each employee has an additional attribute "E_em_dob", the employee's date of birth and each cost accounting staff has an additional attribute "C_st_dob", the staff's date of birth.

Please draw the Classic Star Schema!

Solution

The Star Schema for this case includes a central fact table and four dimension tables. The dimension tables consist of a generated key as well as a key and a text field for each hierarchy (except the total aggregation) and the level attribute. The fact table uses the generated keys from the dimension tables as a combined key and contains the key figure "costs" in this example:

Figure L.E.4.1 - The Classic Star Schema

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

Exercises List