Hi! I have a "duration" attribute in one of my facts tables. Until now this attribute was stored as a string (could be "5","100", but also "Unreliable","Unknown"). Recently the need to compute average values on this attribute arised, sliced by dimension.
Does anyone know the typical workaround for such a situation ? 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. What do you think ? PS: if some of you are coming to http://www.metrorubyonrails.com/ (Paris), I'll give an AW-ETL project feedback presentation there. cheers Thibaut Barrère -- http://www.logeek.fr
_______________________________________________ Activewarehouse-discuss mailing list Activewarehouse-discuss@rubyforge.org http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
