Hello All.

Analysis Services - Cubes.

I have a measures field which is the total number of seconds spent on calls
by our salespeople. I'd dearly like to be able to display this in hh:mm:ss
format. e.g. 3661 seconds = 01:01:01

Not a clue how to do it. I've tried using the Generate - String function,
but to no avail.

Can anybody help?

Many thanks

Ben

This old posting by Deepak might contain some useful information for you
http://groups.google.co.uk/group/mic...e208f6e387d37c

Chris
--
Blog at:
http://spaces.msn.com/members/cwebbbi/


"BenBoardwell" wrote:

Not sure if this is particular to my setup, but the ol' VB functions like
int() and str() may be available to you even if they are not listed by
Analysis Services. You may also have Excel and VBA functions available as
well. I don't know of a modulus operator, though.

"BenBoardwell" <BenBoardwell (AT) discussions (DOT) microsoft.com> wrote

Thanks for the help Chris and Dust'. Eventually used a combination if T-SQl
(DateAdd) vb (format) and vba (IIF) to get the job done.

e.g. format(DateAdd("s", IIf([Measures].[Answered]>0, [Measures].[Talk
Time]/[Measures].[Answered], 0)
, "01 jan 1900"),"hh:mm:ss")

Ben

"BenBoardwell" wrote: