MS SQL Server OLAP - OLAP & Time

Author

OLAP & Time

Richard Mabbitt

2006-01-30, 11:25 am

Hi

I have a calculated measure which is a number of seconds.
I want to display this in the form hh:mm:ss without the end user having do
to anything.
How can i do this?

Regards,
Richard

Jimmy

2006-01-30, 1:24 pm

Look into the Format function.

"Richard Mabbitt" < RichardMabbitt@discu
ssions.microsoft.com> wrote in
message news:DF2876E3-90B3-4175-996C- 79FAE94D90D4@microso
ft.com...
> Hi
>
> I have a calculated measure which is a number of seconds.
> I want to display this in the form hh:mm:ss without the end user having do
> to anything.
> How can i do this?
>
> Regards,
> Richard

Deepak Puri

2006-01-31, 3:23 am

Hi Richard,

This earlier post provides some suggestions:

http://groups.google.com/group/micr....olap/msg/947b1
2d2b1929a08[color=da
rkred]
...
Try the following format, if time is < 32K seconds:

With Member [Measures].[FormattedASA] as
'TimeSerial(0,0,[Measures].& #91;Av_gSpeedAnswer]
)',
FORMAT_STRING = 'hh:nn:ss'
...[color=darkred]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.droptable.com ***

Sponsored Links