-
using 2 different measures and 2 different sets
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.
-
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
-
Thank you Bill, your articles helped me a lot.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|