Clarity

After running the "Load Data Warehouse" job without errors, I have a data warehouse with an empty table DWH_INV_SUMMARY_FACTS.

For Team, Task and Assignment, I have all the data as well as for the weekly and calendar periods. Only the Project-level summary is missing.

In the bg-dwh.log, no errors are shown and even iin the DWH_CFG_AUDIT table, two seconds between start and end of loading have been logged.

What is odd, is that the table DWH_X_INV_SUM_FACTS shows one single project. As I understood, this table is used to update the DWH_INV_SUMMARY_FACTS? How come only one project is found here?

Any ideas on where to investigate further?

Thanks for your support!

Hi Georg,

If you look in your PPM table pac_mnt_projects, how many projects do you see there?

Also, if you create a new project and run the Load DWH job, does it appear in DWH?

Kind Regards

Nika Hadzhikidi

CA Technologies

Principal Support Engineer

Hi Nika,

thank you very much for your reply!

I created a new project and ran a full load of the DWH:

- The project appears in pac_mnt_projects

- The project is shown in the project managment domain

- The custom attributes are there

- The calendar periods are there

- The DWH_INV_SUMMARY_FACTS is still empty

To sum up:

Everything works fine, only the summary table seems to be the problem.

Hi Georg,

It looks like the Project summary facts are not taken somehow. Could you please raise a case with us in Support so we can take a closer look? Thank you very much!

Kind Regards

Nika Hadzhikidi

CA Technologies

Principal Support Engineer

Did you ever get an answer to this issue?

Hello,

Did you get answer for this issue?

Kind Regards,

Abhijit

Hello,

please check for all jobs relevant for the financial data to be populated:

Project Cost and Effort - CA PPM - 14.4 - CA Technologies Documentation 

Regards

Georg