CrossPosting!

I have a Cube with a Measure called TimeTaken. This is stored in seconds, but the user wants the data to be displayed as as HH:MM:SS.

How do I accomplish this?

Raj More.

Here is a suggestion from my earlier post. This example is for a
query-defined Calculated Measure, but you can use similar syntax to
create a Calc.Measure on the server:

http://groups.google.com/groups?q=pu...&lr=&ie=UTF-8&
oe=UTF-8&selm=3e1a01c42a81%2406228590%24a501280a%40phx.gb l&rnum=1
Subject: Time format Measure
This is the only article in this thread
View: Original Format
Newsgroups: microsoft.public.sqlserver.olap
Date: 2004-04-24 21:53:31 PST

Try the following format, if time is < 32K seconds:

'TimeSerial(0,0,[Measures].[AvgSpeedAnswer])',
FORMAT_STRING = 'hh:nn:ss'

helpdesk. However I'd like to show no 200 seconds in the
cube but '00:03:20'. Is it possible?

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!