Using ROLLUP command, generate a monthly sub_total, yearly sub_total and grand total of each distinct product. Display Product descriptions

 

Transcribed Image Text:

Product Dimension Product Key Product ID Product Description Product Code Brand name List Price Min Price Price Start Date Price End Date Current Rag Time Dimension Day Key Actual Date Day of month Month Quarter Year Sales Fact OrderDate Key(K) Product Key(FK) Customer Key FK Employee Key FK) Sales Dollar Amount Quantity Customer Dimension Customer Key Customelo Name Address City State Zip code Area code Phone number Credit Im comments Employee Dimension Employee Key Employee First name Middle initial Last name Sex Manager jd Hire date Salary Commission Job code dob Product Dimension Product Key Product ID Product Description Product Code Brand name List Price Min Price Price Start Date Price End Date Current Rag Time Dimension Day Key Actual Date Day of month Month Quarter Year Sales Fact OrderDate Key(K) Product Key(FK) Customer Key FK Employee Key FK) Sales Dollar Amount Quantity Customer Dimension Customer Key Customelo Name Address City State Zip code Area code Phone number Credit Im comments Employee Dimension Employee Key Employee First name Middle initial Last name Sex Manager jd Hire date Salary Commission Job code dob

Answer rating: 100% (QA)

To generate a report with a monthly subtotal yearly subtotal and grand total for each distinct product including product descriptions using the ROLLUP ... View the full answer