stevefromOZ (2/18/2015)
IF you take Martin's approach, you'll be able to report on the individual 'season product' but also the product in total, regardless of the seasonal variant.
Yeah, I'm following this approach on a similar retail project right now...and it works well.
If you have separate dimensions, you'll end up combining them in the cube anyways...or associate the two dimensions through the facts, which may be dangerous because the relationship will then be dependent on the existence of fact records.