Hi all gurus

In my fact table i have two columns for date data type.
I want sum of its difference as a measure.

How can I get it?

--
Thanks

Am

Assuming the data source is SQL Server and the fact table columns are
BegDate and EndDate, then add a cube measure like [SumDateDiff] with
aggreagation function of 'sum'. Then define the measure 'source column'
as SQL expression:

DateDiff(dd, myfact.BegDate, myfact.EndDate)

(assuming that the difference is computed in days)


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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