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?
V/r Anthony On Dec 7, 2007 10:46 AM, Thibaut Barrère <[EMAIL PROTECTED]> wrote: > 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 > > _______________________________________________ Activewarehouse-discuss mailing list Activewarehouse-discuss@rubyforge.org http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
