I have started developing a SQL query based jasper report. I have custom attributes on project object which are not appearing in data warehouse project related tables. Project object is enabled for data warehouse load.
How should I get these attributes in data warehouse db. Also how custom objects enabled for DHW load will show in data warehouse db after job completes?
To enable the custom attributes you can navigate to the object and select the attribute and there is a button called Include in Dataware house
I selected the custom attributes and enabled for DWH but for few attributes I am getting message like below.
The below attributes could not be included in the Data Warehouse. If the attribute is lookup, query is not DWH compatible.
The look up needs to have certain mandatory attribute for lookups in order to be allowed for Dataware house. Have a look at the articles Kathryn_Ellis publishe
Rules for Including Dynamic Query Lookup Attributes in the Data Warehouse | CA PPM Cookbook
CA PPM Tech Tip: Including Dynamic Query Lookup Attributes in the Data Warehouse