> Shouldn't duration be a dimension? If the value is being stored in the > fact table as a measurement then it should be an additive or > semi-additive value, of which string is neither. Would it be possible > for you to store it in a dimension?
Yes it's possible, although less comfortable ! I've kept some dimension-like fields as attribute of the fact for simplicity so far. >> I've got one idea: replacing this column by two; one would keep the quality >> of the data, "Reliable","Unreliable", "Unknown" to be able to filter relevant >> data, the other one would keep an integer value, and some default value when >> nothing reliable or known is available. 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 ? -- Thibaut
_______________________________________________ Activewarehouse-discuss mailing list Activewarehouse-discuss@rubyforge.org http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
