The value of fact 1 is 22:44 representing is 22 hours and
44 minutes.

The value of fact 2 is 8:40 representing 8 hours and 40
minutes.

AS2K is returning 7:25 which is representing (22:44 +
8:40) = 31:25 - 24. The format on the field is hh:mm. A
format of dd hh:mm results in 06 22:44 and 06 8:40 and 14
07:25. The field type is dbtime. I have dbdate and
dbtimestamp with similar results.

Is this a bug? Does any have a solution if not a bug or a
work around if a bug?

Are you looking at VALUE or at FORMATTED_VALUE cell property ?
If you execute the query from MDX Sample, you can double click on the cell
to see both of them.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

I have the same issue. My question is what data types to
use on the fact table (currently datetime) and for the
measure in the cube (currently DBTime) to make this work.
I am only interested in the time value, not the date. The
measure is a time interval in minutes and seconds at the
base level. Aggregation is fine as long as the total
doesn't exceed 24 hours. Using 'dd' in the format string
gives the day from the date part of the input. Since I
can't enter a zero date, and I can't find a 'Time only'
format, the aggregation for days is coming from the date
rather than the total hours.

Any suggestions appreciated

"Martin Harmelin" <martinh (AT) cubespace (DOT) com.au> wrote

Interesting problem. The only suggestion I have is to use DATEPART SQL
function on the measure to convert it to another data type, like integers
and extract count of minutes. Then minutes will get aggregated properly and
for display purposes can be reformated as hh:mm.
I am curious if somebody came up with better solution.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================