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

Exercise No. 25: Cab Ride (apa)

This cube stores data about a cus­to­mer ri­ding in a cab.

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

Table A.E.51.1 - cab ride

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

1) "a daily re­port of each com­bi­na­ti­on of dri­ver and cus­to­mer in­de­pen­dent of the car"

2) "a roll-​up by the time di­men­si­on star­ting at month for each type of car"

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

So­lu­ti­on

This ex­er­ci­se is part of a case study: dfm - apa - log

Ex­er­ci­s­es List