Tasks: In this assignment we are going to use perform OLAP operations on a cube called TS located in a multidimensional database called Time Series that has been defined based on the tables in the database given by the description below:

Tb_Supplier(Supp_ID, Name, City, State)
Tb_Consumer(Con_ID, Name, City, State)
Tb_Product(Prod_ID, Name, Product_Category, Product_Line, Product_Packaging)
Tb_Offers(Supp_ID, Prod_ID, Quantity, Price)
Tb_Requests(Con_ID, Prod_ID, Quantity, Price)
Tb_Transactions(Tran_ID, Supp_ID, Con_ID, Prod_ID, Quantity, Price)
Tb_Date(DateKey, DateYear, DateMonth, DateMonthName, DateWeek, DateDayOfMonth, DateDayOfWeek, FiscalWeek, IsWeekEnd, IsHoliday, HolidayName)
Tb_Time(TimeKey, TheHour, IsLunchHour, IsBusinessHour, ShiftNumber)
The dimensions of the cube are: Tb_Supplier, Tb_Consumer, Tb_Product, Tb_Date and Tb_Time.

Measure groups are: Tb_Offers, Tb_Requests and Tb_Transactions.

The following dimension hierarchies have been defined within the dimensions:
Tb_Supplier dimension: SH hierarchy: State > City > Name
Tb_Consumer dimension: CH hierarchy: State > City > Name
Tb_Product dimension:
HNP hierarchy: Product_Packaging > Name
HNLC hierarchy: Product_Category > Product_Line > Name

In addition, there are several hierarchies defined on the Tb_Date dimension.

Tb_Date dimension:
HMOFY hierarchy: Date Month Of Year > Date Month Name > Date Month > Date Key
HMQY hierarchy: Date Year > Date Quarter > Date Month > Date Key
HQOfY hierarchy: Date Quarter Of Year > Date Quarter > Date Month > Date Key
There are no hierarchies defined on the Tb_Time dimension.

Given the TS cube solve the following queries:
3. Quantity of milk sold in each consumer city (on rows) during first quarter of 2019 vs first quarter of 2018 (on columns) (use PARALLELPERIOD())?