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?