S-Curve of Baselined PV vs EV actuals

[KarenF]

Does anyone know how to calculate Cumulative Baseline work using this
information for the S-curve in Portfolio Analyzer?
http://techrepublic.com.com/5100-6329_11-5030578.html

Thanks,
KarenF

 

[Gérard Ducouret]

Karen,

The formula for cumulative Baseline Work is the OLAP Cube would be something
like that:
Round(Sum(PeriodsToDate([Time].[All]),[Measures].[Baseline Work]),0)



Hope this helps,



Gérard Ducouret

 

[Dale Howard [MVP]]

KarenF --

Create the View according to Brian's directions, however, you'll need to do
the following:

1. Drag the Baseline Work field to the Total Fields drop area
2. Create the formula for the S-Curve using the following:

Sum(PeriodsToDate([Time].[All]),[Measures].[Baseline Work])

Hope this helps.

 

[KarenF]

Gerard and Dale,
Thanks for your quick response. I did use this formula, but my Cumulative
Baseline work column numbers equal the Baseline work numbers in my Portfolio
analyzer. I don't know why they would be equal. Am I missing an add-on or
functions in my OLAP cube?
Thanks for your help.

KarenF

KarenF --

Create the View according to Brian's directions, however, you'll need to do
the following:

1. Drag the Baseline Work field to the Total Fields drop area
2. Create the formula for the S-Curve using the following:

Sum(PeriodsToDate([Time].[All]),[Measures].[Baseline Work])

Hope this helps.

Does anyone know how to calculate Cumulative Baseline work using this
information for the S-curve in Portfolio Analyzer?
http://techrepublic.com.com/5100-6329_11-5030578.html

Thanks,
KarenF

 

[Gérard Ducouret]

Karen,
Try to change the timescale. Look at the begining of the X axis...

Gérard Ducouret

Gerard and Dale,
Thanks for your quick response. I did use this formula, but my Cumulative
Baseline work column numbers equal the Baseline work numbers in my Portfolio
analyzer. I don't know why they would be equal. Am I missing an add-on or
functions in my OLAP cube?
Thanks for your help.

KarenF

KarenF --

Create the View according to Brian's directions, however, you'll need to do
the following:

1. Drag the Baseline Work field to the Total Fields drop area
2. Create the formula for the S-Curve using the following:

Sum(PeriodsToDate([Time].[All]),[Measures].[Baseline Work])

Hope this helps.

Does anyone know how to calculate Cumulative Baseline work using this
information for the S-curve in Portfolio Analyzer?
http://techrepublic.com.com/5100-6329_11-5030578.html

Thanks,
KarenF