Hello:

I have a fact table that have two dates, Start_DT and End_DT. I want to
create a measure that calculates the days between the End_DT and Start_DT.

I already have set up a cube that calculates oher measures. How can I add
this measure to the cube?

I tried editing th cube but am at a loss trying to create this calculated
measure.

Thanks.

Venkat

I know how to define a base measure. In AM, you can choose any of the 2
columns to create a new measure, then change the measure's definition to
datediff(day, start_DT, end_DT). (Choose sum as aggregation function?) You
also need to make sure the aggregation along various dimensions to be
meaningful.

James

"vvenk" wrote: