Custom Duration in OLAP Cube Data Analysis

[Drew]

I have a custom field that is used as a metric. It is calculated by
calculating the difference between the actual finish date and baseline
finish date of a milestone (if the actual date was late). I have
created this calculated field in MS Project with the following
formula:

IIf(ProjDateDiff([Baseline Finish],[Finish])>0,ProjDateDiff([Baseline
Finish],[Finish]),0)

I would like this field to show up in a custom Data Analysis view, but
I can't seem to add it to a Cube. Is it possible to add a calculated
field like this to the Cube?

Thanks,
Drew

 

[Sunil Kr Singh]

Calculated metrics can't be added to cube as a measure, but workaround
suggested would be to create a Custom Text/Number Field >> write a macro to
copy all data from calculated field to text field>> push this text/number
field to cube

Thanks
Sunil

 

[Sunil Kr Singh]

Hi Drew
calculated metrics can't be added to cube as a measure, refer to the link
for further information http://msdn.microsoft.com/en-us/library/ms447495.aspx
workaround suggested would be to create a Enterprise Text / Number Custom
field >> write a macro which will copy all values from calculated field to
new Text/number custom field >> now push this Text / number field to cube

Regards
Sunil