using 2 different measures and 2 different sets

[zmike]

Hello.



i have dimensions: month, country, customer, item.
measures: amount, price.

i would like to get such result :

for each customer from USA: sum (amount of item in June * price for the same
item in January).

is it possible?

thank you for your help, Mike.

[Island1]

Depending upon cube construction, this is not only possible, but so common that MDX includes time functions to make it easier.

See my articles at:

http://www.databasejournal.com/featu...le.php/3073581

---> (your case sounds like a possible "parallel period" scenario, but I'd need to know more about cube structure to say for sure...)

http://www.databasejournal.com/featu...le.php/2232111


http://www.databasejournal.com/featu...le.php/2245791

Hope this helps - best of luck!

Bill

[zmike]

Thank you Bill, your articles helped me a lot.