Need answer in 1 hr :-)

You have on your site the following question - No answer though just master answer will be posted- can I get answer now to question?

Question: 1. Consider the following data warehouse schema: Tb_Supplier(Supp_ID, Supplier_Name, Supplier_Cit...

1. Consider the following data warehouse schema:

Tb_Supplier(Supp_ID, Supplier_Name, Supplier_City) Tb_Consumer(Con_ID, Consumer_Name, Consumer_City) Tb_Product(Prod_ID, Name, MU) Tb_Transactions(T_ID, Supp_ID, Con_ID, Prod_ID, Quantity, Price)

where

Tb_Supplier, Tb_Consumer, Tb_Product

are dimension tables,

Tb_Transactions

is a measures table containing individual transactions data, and

Supplier_Name < Supplier_City, Consumer_Name < Consumer_City

are concept hierarchies in tables Tb_Supplier and Tb_Consumer.

Given the query: What are the totals sells of auto by supplier-city to consumers in Chicago? Which of the following OLAP operations need to be applied to the

(supplier-city, consumer-city, product)

cuboid in order to solve the query?

Group of answer choices (Select all that apply.)

1. reduction of dimension product

2. hierarchy climbing on the supplier dimension

3. dice by product name is auto and consumer city is Chicago

4. hierarchy climbing on the consumer dimension

5. reduction of dimension supplier

6. slice by supplier city

7. reduction of dimension consumer