SSAS MDX Query The following is the database configuration: Supplier(Supp_ID, Na

Question

SSAS MDX Query The following is the database configuration:

Supplier(Supp_ID, Name, City, State)

Consumer(Con_ID, Name, City, State) P

roduct(Prod_ID, Name, Product_Category, Product_Line, Product_Packaging)

Offers(Supp_ID, Prod_ID, Quantity, Price)

Requests(Con_ID, Prod_ID, Quantity, Price)

Transactions(Tran_ID, Supp_ID, Con_ID, Prod_ID, Quantity, Price)

Measures only come from the Transactions table and are the following: Price, Quantity, and Count

I am asked to do the following:

For each product list quantity sold by suppliers in Madison to consumers in Chicago versus quantity sold by suppliers in Chicago to consumers in Madison (result columns will be: product name, quantity Madison_Chicago, quantity Chicago_Madison?

I cannot seem to figure out how to join the two MDX queries that answer the question and alias the columns.

Explanation / Answer

SELECT NON EMPTY {
[Measures].[Quantity - Transactions], [Measures].[Transactions Count],
[Measures].[Price - Transactions] } ON COLUMNS, NON EMPTY {
[Product].[Name].[Name].ALLMEMBERS } ON ROWS FROM [DS710]
WHERE ([Tb Consumer].[State].&[Chicago] & [Tb Supplier].[State].&[Madison])

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.