S Curves graph with BCWS, BCWP and ACWP on OLAP cube

[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!

 

[Sunil Veettil]

Robert,

I am trying to find this out, did you find the solution?

Thx



Robert wrote:

S Curves graph with BCWS, BCWP and ACWP on OLAP cube
11-Nov-08

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!

EggHeadCafe - Software Developer Portal of Choice
Easy "NO SCRIPT" DataGrid Tooltips in ASP.NET
http://www.eggheadcafe.com/tutorial...f5c-0e18fa4e2e43/easy-no-script--datagri.aspx