Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Table 2.0 below shows the representation of sales amount for Suria Sdn Bhd company according to the type of items for January 2019 2018

Table 2.0 below shows the representation of sales amount for Suria Sdn Bhdcompany according to the type of items for January 

Table 2.0 below shows the representation of sales amount for Suria Sdn Bhd company according to the type of items for January 2019 2018 Items Mobile Phone Laptop Printer Table 2.0: Sales Volume for Suria Sdn Bhd January 2019 July 2018 Serauak Locations evs Pahang 150 bedah Perak- 150 150 Terengganu 100 150 Kelantan 150 170 105 100 100 150 130 1. The table above shows the representation of sales amount for Suria Sdn Bhd company according to the type of items for Jan 2019 a. Identify the appropriate fact and dimension tables b. Construct the three-dimensional data cube using the data from above table. Assume the data will be provided until june 2019 C. Explain the difference between a slice and a dice d. Illustrate your answer with an example from table above. Slice for sales volumes for time/year = jan 2019 e. Illustrate your answer with an example from table above. Dice for sales volume for time/year = Jan 2019 and item = Printer

Step by Step Solution

3.32 Rating (149 Votes )

There are 3 Steps involved in it

Step: 1

Code Appointmentjava public class Appointment data members String type int patientID String patientName String appointmentDateTime String doctorName String details public AppointmentString type int pa... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microeconomics

Authors: Robert Pindyck, Daniel Rubinfeld

8th edition

978-0132870436, 132870436, 013285712X, 978-0133371178, 133371174, 978-0132857123

More Books

Students also viewed these Accounting questions

Question

What are the advantages and disadvantages of Agile PM?

Answered: 1 week ago