Data Analysis - Cummulative calculations

[Sindre]

Hi!

I am trying to create a view which includes cummulative work by adding a
calculation, and I want the cummulative value to span all time periods. To do
this I have tried to use:
Sum(PeriodsToDate([Time].[All]),[Work])

This results in the following error:
Value: #VALUE!
The PERIODSTODATE function expects a level expression for the argument. A
member expression was used.

If I use [Year] or [Month] instead of [All] it works fine, but that of
course limits the time period on which the accumlation is done as well. I
have read several guides and forum posts stating that using [All] should work
just fine though, so any help on this subject will be appreciated.

I am using Project Server 2007 and Analysis Services 2005.

Regards,
Sindre

 

[Mike]

Hi!

I am trying to create a view which includes cummulative work by adding a
calculation, and I want the cummulative value to span all time periods. To do
this I have tried to use:
Sum(PeriodsToDate([Time].[All]),[Work])

This results in the following error:
Value: #VALUE!
The PERIODSTODATE function expects a level expression for the argument. A
member expression was used.

If I use [Year] or [Month] instead of [All] it works fine, but that of
course limits the time period on which the accumlation is done as well. I
have read several guides and forum posts stating that using [All] should work
just fine though, so any help on this subject will be appreciated.

I am using Project Server 2007 and Analysis Services 2005.

Regards,
Sindre

Hi Sindre

This seems to be a change / issue with AS 2005 (not PS2007). As you
say, you can generate a period accumulation set of data(could replace
Fiscal Year, by Fiscal Qtr or Month and it will accumulate in that
time frame using the following):

Sum(Periodstodate([Fiscal Time].[Fiscal Year],[Fiscal
Time].currentmember),[Measures].[Work])

However with my limited AS skills I cannot define a "level" above Year
which would handle a project going across multiple years.

Any further contribution from someone would be appreciated.

regards

Mike

 

[Sindre]

Hi!

I am trying to create a view which includes cummulative work by adding a
calculation, and I want the cummulative value to span all time periods. To do
this I have tried to use:
Sum(PeriodsToDate([Time].[All]),[Work])

This results in the following error:
Value: #VALUE!
The PERIODSTODATE function expects a level expression for the argument. A
member expression was used.

If I use [Year] or [Month] instead of [All] it works fine, but that of
course limits the time period on which the accumlation is done as well. I
have read several guides and forum posts stating that using [All] should work
just fine though, so any help on this subject will be appreciated.

I am using Project Server 2007 and Analysis Services 2005.

Regards,
Sindre

Hi Sindre

This seems to be a change / issue with AS 2005 (not PS2007). As you
say, you can generate a period accumulation set of data(could replace
Fiscal Year, by Fiscal Qtr or Month and it will accumulate in that
time frame using the following):

Sum(Periodstodate([Fiscal Time].[Fiscal Year],[Fiscal
Time].currentmember),[Measures].[Work])

However with my limited AS skills I cannot define a "level" above Year
which would handle a project going across multiple years.

Any further contribution from someone would be appreciated.

regards

Mike

I am still looking for help on this topic, any help would be appreciated.

-Sindre