in Data warehouse

oooo STC 7:28 PM ASS 1-IS 322D.docx Question 3: Answer the following queries by showing the result for each dimension in the result cube. (Show the display of the query as how it will affect the rows, columns, and pages) Chicago New York Toronto Vancouver 02 03 04 Mobile Modem Phone Security a. Display the total sales of all items for the Quarters Q2 and Q4 in all cities b. Display the total sales of Mobile, Modem and Security in New York and Vancouver for all Quarters c. Show the comparison of all sales for Q2 and Q4 in all cities item by item, only for those items with decreased sales d. Show the result of the first page (Vancouver) after rolling up items one level up, knowing that Mobile and Phone are from category X, Modem and Security are from category Y Open With Print oooo STC 7:28 PM ASS 1-IS 322D.docx Question 3: Answer the following queries by showing the result for each dimension in the result cube. (Show the display of the query as how it will affect the rows, columns, and pages) Chicago New York Toronto Vancouver 02 03 04 Mobile Modem Phone Security a. Display the total sales of all items for the Quarters Q2 and Q4 in all cities b. Display the total sales of Mobile, Modem and Security in New York and Vancouver for all Quarters c. Show the comparison of all sales for Q2 and Q4 in all cities item by item, only for those items with decreased sales d. Show the result of the first page (Vancouver) after rolling up items one level up, knowing that Mobile and Phone are from category X, Modem and Security are from category Y Open With Print