AnsweredAssumed Answered

Pending actual in DWH

Question asked by Sreeram601 on Jun 20, 2016
Latest reply on Jun 27, 2016 by Nika_Hadzhikidi

Hi,

 

I'm trying to design the code to get the pending actual for each resource with respect to task /investment. I was able to acheive in getting the ETC & Actual on Monthly (period) basis using the table DWH_INV_ASSIGN_PERIOD FACTS.  But to get the pending actual which is available in DWH_INV_ASSIGN_SUMMARY_FACTS but no period_key is avaiable.

 

So if any one have achieved in getting the report(Table) query to get Resoure name, Investment Name, Task Name, Monthly period, Actuals, ETC and pending Actual, please do share.

 

Thanks

Sreeram

Outcomes