COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: Snavelyone on 14 Sep 2008 08:05:59 PM

Title: Convert seconds to HH:MM:SS
Post by: Snavelyone on 14 Sep 2008 08:05:59 PM
I am able to convert my talk time from seconds to HH:MM:SS and publish my IQD. When I bring it in as a measure I get error TR0210 or if I break them up Hours, Minutes, Seconds and try to create a measure by concating them it just shows 0's. Has anyone tried to convert seconds to HH:MM:SS and use it as a measure in Transformer???????
Title: Re: Convert seconds to HH:MM:SS
Post by: atnaatna on 05 Jan 2010 11:25:18 AM
You should just keep the measure as seconds.  When you convert it to HH:MI:SS and try to use it as a measure it does not make sense as Transformer does not know how to roll this value up since "HH:MI:SS" is really a string.