My team is relatively new to CA PPM and we're attempting to utilize advanced reporting to report on baselines. However, we are confused how the calculation for Total Baseline Hours occurs in the Project Management Domain. The domain's seem very vague to me, but I may just be missing something.
What is the best way to check something like this? I tried to view the domain in Jaspersoft's Domain Designer, but I was unable to find anything useful for the attribute(JoinTree_1.DWH_INV_SUMMARY_FACTS.BASE_TOTAL_HOURS).
Any help is appreciated! We'd really like to have a better understanding in this area.
The values in DWH_INV_SUMMARY_FACTS, and in your example, DWH_INV_SUMMARY_FACTS.BASE_TOTAL_HOURS are getting summed up from the values in DWH_INV_ASSIGN_PERIOD_FACTS table.
And before the data gets to DWH with Load Data Warehouse job, in PPM, the data is taken from view DWH_INV_ASSIGN_PER_FACTS_V. There is no way for you to actually see this from the Domain properties, I think the only thing you will see is the table/fields, but it won't show where the actual data is coming from.
Please let me know for any questions.
Nika HadzhikidiCA TechnologiesPrincipal Support Engineer