1. Generate a data cube that shows product category sales in each quarter of 1997. In order to see if there is clearly sales trend for each product category, you want to show category first and then quarter, and then the quarterly sales of the category.

Select P.CategoryName, T.Quarter, SUM(Units) AS Total_Units, format (SUM(F.revenue),2)AS

Total_Revenue

From FactTable F

Join TimeDimension T ON F.DateID=T.DateID

Join ProductDimension P ON F.ProdctID = P.ProductID

Where T.Year=1997

Group by P.CategoryName, T.Quarter;