I am a new guy to mdx. i was working on a job of analys the profit depend on customers from different counties. Maybe the structure of table is complicated.
The relationships of table are below.
Sort:: table which use to store the county.
User: table used to store user information
Account: table used to store user's account information, one user has one or more account.
Order: used to store account's order information. one account has one or more orders.
OrderItem: used to store order items in the order, one account has one or more items.
Now I need to know how many orders had been made depend on different counties and time period. I can implement time dimention, but the location dimention,
due to the county information are store in user table, I don't know how to implement it into mdx.
View Complete Post