Question
Consider a data warehouse for a train company, which wishes to study sales of train tickets. The data warehouse has dimensions on time, customers, routes,
Consider a data warehouse for a train company, which wishes to study sales of train tickets. The data warehouse has dimensions on time, customers, routes, and trains, and it also includes a measure on ticket amount. The time dimension has a hierarchy of date & time < date < month < year.
1. How many cuboids will the cube contain, including the base and apex cuboids?
2. Starting with the base cuboid [day,customer,route,train], which OLAP operations should be performed in order to list the total amount of tickets collected for a specific route (e.g. Route243), for a given year (e.g. 2021)?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started