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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

OPENING VIGNETTE: NORFOLK SOUTHERN USES BUSINESS INTELLIGENCE FOR DECISION SUPPORT TO REACH SUCCESS There are four large freight railroads in the United States, and Norfolk Southern is one of them....

PLEASE SEE BELOW CASE STUDY AND THE QUESTIONS FOR THE REPORT IS AT THE END. Answer the 6 questions at the end of the case study in the form of an essay, using each of them as a heading and relating...

PLEASE SEE BELOW CASE STUDY AND THE QUESTIONS FOR THE REPORT IS AT THE END. WRITE IN THE FORM OF AN ESSAY AND NOT A QUESTION AND ANSWER Sustainable Supply Chain 010 Assignment (2022 Tri 2) This is...

\f\f\fChapter 2 Service Strategy Learning Objectives After completing this chapter, you should be able to: 1. Formulate a strategic service vision. 2. Describe how a service competes using the three...

1) Read the "Cybersecurity: the three-headed Janus" case posted under Module 2. Provide a summary of the vulnerabilities of Randcom's current information systems. Make sure to address each...

ARENA SIMULATION IIE/RA Contest Problems h Annual Contest: SM Theme Parks SM Theme Parks is the parent company for a series of theme amusement parks located primarily in the southern part of the...

What attributes should the company focus on while designing the communication plan? For the exclusive use of J. Barry, 2020. A00183 March 31, 2014 Revised 18 June 2019 Cerenity Sanitiser: Marketing...

PLEASE JUST SOLVE TASK 1 Consider a fictional cinema operator called Al Sinama (AS). The CEO of AS wants to build a data warehouse to analyze ticket sales. Design a ROLAP for this purpose. Task 1:...

ASSUMPTION UNIVERSITY GRADUATE SCHOOL OF eLEARNING Master of Science in Management SCIT Building 9th floor, 88 Moo 8 Bangna-Trad Km 26, Bang Sao Thong, Samutprakarn 10540 Thailand Tel: + 66 2 7232944...

Individually, or in groups of two or three, you will plan and implement a project to accomplish a meaningful change. Your project must result in a change in process, system, or structure within the...

A cab company, EasyRide, has been operating in business since 1st January 2022 and prepared the Trial Balance as below. Easy Ride Trial Balance - December 31, 2022 Debits () Cash Accounts Receivable...

A company borrows $68 comma 000 for 8 years at a simple interest rate of 15.5%. Find the interest paid on the loan and the total amount paid

Your acquaintance, Vic Velakturi, owns a store that sells households daily usage products. Velakturi acquires her goods from a few select vendors. She generally makes purchase orders by on account....

1. Why was data management so problematic at ARI? Automotive Resources International, better known as simply ARI, is the worlds largest privately-held company for vehicle fleet management services....

5-19 What is the total cost of ownership of technology assets and what are its cost components?

5-16 Compare the BYOD experiences of IBM and Intel. Why did BYOD at Intel work so well? Just about everyone who has a smartphone wants to be able to bring it to work and use it on the job. And why...