Out of box Status attribute under object Roadmap Item unavailable in Dataware house Schema
Steps to Reproduce
Expected Result: Since the attribute is checked for Include in the Data Warehouse it should be available and dataware schema. Validate the same by running the below queries
--Query to check the reference in the DWH_META_COLUMNS
SELECT * FROM DWH_META_COLUMNS
WHERE OBJECT_CODE = 'rdm_roadmap_item';
--Query to check the reference in the DWH table dwh_rdm_roadmap_item
SELECT * FROM dwh_rdm_roadmap_item;
Both the queries will not show up the status attribute
Actual Result: Status (status) attribute is still not available in dataware house schema
Currently not all columns is available in dataware house schema.
On Premise Customer can navigate to Clarity_home\META-INF\rdm\dwmd\rdm_roadmap_itemDWMD.xml and see what all attributes are included and that file will contain all the meta data of attributed available for dataware house schema for object Road Map Items
Release : 15.8.1, 15.9, 15.9.1
Component : CA PPM SAAS DATA WAREHOUSE