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,
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started