Hello All,I have tried searching for Budgeted Plan details in DWH and got know it is showing recently approved Budget plan in DWH_INV_SUMMARY_FACTS , where there are few other Budget plans which are Rejected which i need to bring them in my report. (Example:- there are 4 rejected plans and 3 approved plans where only 1 plan is checked for Current)Could you please let me know which table we will find all the Budget plans.Thanks.
Please check the table DWH_FIN_PLAN, it will contain the Cost and Budget plans and you should then be able to join with DWH_FIN_PLAN_SUMMARY_FACTS or DWH_FIN_PLAN_PERIOD_FACTS.
As you didn't specify your CA PPM version, please make sure that if don't have this flag enabled in PPM - Administration - System Options -Data Warehouse Options, this will reduce the number of financial plans brought to DWH:
Also, for more information about all the DWH tables, check the documentation here:
You can check the ERD and "CA PPM Advanced Reporting and Database Schema Index" link referenced, it will get to the download page for the zip file with all schema information.
Hope this helps -Nika
CA PPM version which we are using is 220.127.116.11 01 24
Here there is no such option which is shown in your reply
Okay then it's all good, just go ahead and check on the tables and the documentation.
Hi Nika,I didn't understand what you said, where should i check for the tables and documentation.
On your question, what I said is to try querying the table DWH_FIN_PLAN: if you need more of the data join it with DWH_FIN_PLAN_SUMMARY_FACTS or DWH_FIN_PLAN_PERIOD_FACTS. This should help you.
For additional information about these tables above or any other Data Warehouse of CA PPM tables and the fields they contain:
I hope this helps -Nika