That's a bit of edge case yes.. Thanks for your answer, appreciated!
-- Thibaut I would suggest that unless it is a FK to a dimension, a degenerate > dimension (which in this case may have been the case for the duration) > or a measurement (which also may be the case for the duration) then it > should not be in the fact table. I think the question of duration is a > bit sticky because on the one hand it is a measurement, but on the > other it can have values that are non-numeric if you allow it to do so > (which you do). > > > If I transform it into a dimension, should I split the value into two > like I > > suggested, to allow filtering ? Or is there another practice ? > > Yes, I think you should separate it into multiple values.
_______________________________________________ Activewarehouse-discuss mailing list Activewarehouse-discuss@rubyforge.org http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
