Non-Plan of Record information is not included in Advanced Reporting nor the Data Warehouse

Document ID : KB000012485
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

When viewing or creating a report in Advanced Reporting, we find that the Data Warehouse does not contain information on cost plans and budget plans that are not designated as being part of the financial Plan of Record. Why is this information not available for inclusion in the reports? Our users utilize information from the Non-Plan of Record financial plans significantly.

Environment:
This applies to CA Product Portfolio Management (PPM) 14.4, 15.1, and above.
Answer:

Beginning with PPM 14.4, not all cost plans and budget plans are loaded into the Data Warehouse when the Load Data Warehouse - Full job is run. Instead, the following financial plans are added to the Data Warehouse, for all applicable investments:

  • The Plan of Record
  • The current budget plan
  • All benefit plans

 

With CA PPM 15.1, there is the option included under Administration > System Options > and under the Data Warehouse Options titled

"Include only financial Plan of Record"

kb_picture.PNG

By default, this setting is enabled such that only Plan of Record financial data is inserted into the Data Warehouse. Turning off this setting will allow for Non-Plan of Record financial information to be populated into the Data Warehouse on the next run of the  Load Data Warehouse - Full job. The information will then be available in the Data Warehouse, and subsequently for use with Advanced Reporting.

The current plans regarding investments can then be compared with previously used plans and reported on. 

Note: Turning off this setting may impact performance of the Data Warehouse, and a significant load run time may be seen for larger data sets.

Additional Information:

This setting in only available for CA PPM 15.1. Information on this particular change is available here for CA PPM 14.4 under the section titled Changes to the Load Data Warehouse Job.

The availability of the option to include only Financial Plan of Record information, and thus ability to turn off this option, is included here for CA PPM 15.1.