R
Robert
Hello,
How can we create the S Curves graph with BCWS, BCWP and ACWP in a Data
Analysis view of PWA 2007 on the OLAP cube for one selected project?
Using the MSP_Portfolio_Analyser cube I succeeded in calculating the ACWP
with the formula :
Sum(PeriodsToDate([Time].[All]),[Measures].[Actual Cost])
For the BCWS I tried the formula:
Sum(PeriodsToDate([Time].[All]),[Measures].[Baseline Cost])
but its result is always 0 for every time unit (week), while I have a
baseline.
Any idea?
Thank for your help!
How can we create the S Curves graph with BCWS, BCWP and ACWP in a Data
Analysis view of PWA 2007 on the OLAP cube for one selected project?
Using the MSP_Portfolio_Analyser cube I succeeded in calculating the ACWP
with the formula :
Sum(PeriodsToDate([Time].[All]),[Measures].[Actual Cost])
For the BCWS I tried the formula:
Sum(PeriodsToDate([Time].[All]),[Measures].[Baseline Cost])
but its result is always 0 for every time unit (week), while I have a
baseline.
Any idea?
Thank for your help!