How come I am not able to include some attributes or fields in the CA PPM Data Warehouse

Document ID : KB000124679
Last Modified Date : 15/01/2019
Show Technical Document Details
Question:
How come I am not able to include some attributes or fields in the CA PPM Data Warehouse for reporting.

For example the following attributes are on the Project Object attributes page but you can't add it to the DWH.
1) Project Financial Status - PAC_MNT_PROJECTS.STATUS
2) Prevent Unassigned Timesheet Tasks - INV_INVESTMENTS.TRACK_ASSIGN_ONLY
Answer:
Some attributes cannot be included in the Data Warehouse database for reporting and this by design. The fields above are not available for inclusion in the DWH by design.

In this situation please check the database table name and the database table column name for each of the attributes and check the schema for those attributes. If they belong to another table and a different object, and if they can be included in the data warehouse on another object.
PPM/DWH Schema reference here:
https://support.ca.com/us/product-content/recommended-reading/product-related-technical-information/ca-ppm-advanced-reporting-and-database-schema-index.html.

If these attributes are not available on any other object in the schema as alternative you may consider create custom domain using the PPM data source and include the desired tables. And then create ad hoc view/report off of the custom domain/tables.

Ad Hoc Views and Custom Report Development:
https://docops.ca.com/ca-ppm/15-5/en/advanced-reporting-with-jaspersoft/ad-hoc-views-and-custom-report-development#AdHocViewsandCustomReportDevelopment-BestPracticesforAdHocViews