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

Exercise No. 36: Budget Rental Service (apa)

The fol­lo­wing cube stores data about the Bud­get car ren­tal ser­vice.

Cars are rent to cus­to­mers who can be clas­si­fied into cus­to­mer groups (pri­va­te, busi­ness, etc.). There's an op­ti­on to rent a dri­ver for the car as well. The car is ser­vi­ced by a ga­ra­ge and be­longs to a branch of the Bud­get car ren­tal ser­vice. This branch be­longs to the na­tio­nal­wi­de ope­ra­ting Bud­get car ren­tal ser­vice

We have five di­men­si­ons with the fol­lo­wing hier­ar­chi­cal struc­tu­re:

Table A.21.5.1 - the Bud­get car ren­tal ser­vice

Plea­se build the Ag­gre­ga­ti­on Path Array and as­su­me the fol­lo­wing end-​user re­qui­re­ments:

1) "a roll up by the time di­men­si­on star­ting at weeks for each cus­to­mer group in­de­pen­dent of the dri­ver, the ga­ra­ge the car is ser­vi­ced and the branch"

2) "a daily re­port for each com­bi­na­ti­on of dri­ver and branch, in­de­pen­dent of the cus­to­mer and the ga­ra­ge"

3) "a weekly re­port for each ga­ra­ge, ir­re­spec­ti­ve of the cus­to­mer, the dri­ver and the branch"

Select the cor­re­spon­ding cells in the APA and choo­se the cubes to ma­te­ria­li­ze, then high­light the de­ri­va­ti­ves of those cubes.

So­lu­ti­on

Ex­er­ci­s­es List