Data Analysis - Cube Calculation

[KarenF]

Hi All,

In Project Server 2003, I was able to create a Portfolio Analyzer view
showing cumulative baseline work with a calculation of:
Sum(PeriodsToDate([Time].[Week]),[Measures].[Baseline Work])
This worked very well.
I am trying to re-create this view in Project Server 2007 with the
same calculation. It is not working - the results I get is the
baseline work value for each week- not the cumulative sum.

Does anyone know if I need a different calculation in PS 2007?

Thanks in advance,
KarenF

 

[Ben Howard]

My understanding is the syntax is the same, however P2007 has week dimensions
for financial periods, timesheet periods etc. Worth just checking that the
time.week dimension is the correct one?

 

[KarenF]

My understanding is the syntax is the same, however P2007 has week dimensions
for financial periods, timesheet periods etc. Worth just checking that the
time.week dimension is the correct one?
--
Thanks, Ben.http://appleparkltd.spaces.live.com/

Hi All,

In Project Server 2003, I was able to create a Portfolio Analyzer view
showing cumulative baseline work with a calculation of:
Sum(PeriodsToDate([Time].[Week]),[Measures].[Baseline Work])
This worked very well.
I am trying to re-create this view in Project Server 2007 with the
same calculation. It is not working - the results I get is the
baseline work value for each week- not the cumulative sum.

Does anyone know if I need a different calculation in PS 2007?

Thanks in advance,
KarenF- Hide quoted text -

- Show quoted text -

Thanks Ben, you're correct. I had to put [time].[all] for it to
work.

KarenF