Project revision tables do not contain the as-of date for the cost or the run date of the revision.
There is an enhancement request pending for HXproject cost history tables to be added to baq visibility (HXProject is visible but none of the other project HX tables are accessible) but there are no relevant date fields in the HX tables to perform project history analysis on, just a rev#. When adding these tables to BAQ visibility there should be a date associated with revision#. This would also be useful in project tracker to search historical revision by date along with rev#.
Begin Existing enhancement request;
Suggested Enhancement: Add Project History tables so they are available to build BAQs.
The table already available is
HXProject
Other tables required are:
HXProjectCriteria
HXProjectCst
HXProjectJob
HXProjectMilestone
HXProjectOrderLine
HXProjectPO
HXProjectQuot
HXProjectTask
HXProjPhase
Purpose: The History Project Header table is exposed in the BAQ designer and contains ‘ProjectID’ and ‘Revision’ key fields. Yet the related History Phase tables and History Phase Cost tables are not available, thus preventing obtaining Project Revision historical data through BAQs and dashboards.
This is especially important in the Public Cloud environment where access to SQL Server databases is not available.
Version: 10.2.400.9
Enhancement is still pending meaning Development hasn’t provided a targeted version where this function is going to be applied.
END existing enhancement request