AnsweredAssumed Answered

How to get time phased cost plan data from Data Warehouse?

Question asked by BradGibson on Mar 17, 2016
Latest reply on Mar 28, 2016 by BradGibson

Advance Reporting:  How to get time phased cost plan data from Data Warehouse?

 

I see that the DWH has summary facts for cost/budget plans such as total planned and actual cost.

How can I pull the data per time period?  I do it in transactional database by going into the time slice db and pulling it by dates there.

I don't see a way to accomplish the same thing in DWH.

 

SO, for example, if I want to know that in the Budget Plan of Record for MARCH the PM planned $10k capex cost type and the actual was $5K capex (by cost type), how can I extract that from the DWH?

Outcomes