Hey all,
Our product structure is:
Category
Class
Subclass
Item
We have 1 measure group by category, and another measure group by item. So we are forced to join by Category. Which works fine except for whereever we join on Category some reason the measures get rolled down all the way to the Item level.
Example:
Category Sales
00001 50.75
Product Measure Group 1 Measure Group 2
Category 00001 50.75 50.75
Class 00002 0.00 50.75
Subclass 00003 0.00 50.75
Item 00004 0.00 50.75
It's important to note Measure Group 1 is ONLY at the category level. Some reason it rolls down when to joni to Measure Group 2? Any ideas how to prevent this?
Thanks a lot.
Hello! I have written a short post about this problem on my blog: http://thomasianalytics.spaces.live.com/blog/cns!B6B6A40B93AE1393!381.entry
My example is from the Adventure Works project but the way to solve this should work for your problem also.
HTH
Thomas Ivarsson
|||Perfect - thanks!
No comments:
Post a Comment