Status Attribute under Object Roadmap Item unavailable at Dataware house Schema

book

Article ID: 208098

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Out of box Status attribute under object Roadmap Item unavailable in Dataware house Schema 

Steps to Reproduce 

  1. Login to Clarity with administration rights 
  2. Navigate to Administration --> Studio --> Object 
  3. Search for object Roadmap Item (rdm_roadmap_item)
  4. Navigate to attributes tab and search for out of box attribute Status (status)
  5. Look for properties under Status (status) attribute and look for Include in the Data Warehouse 

 

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

Cause

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 

Environment

Release : 15.8.1, 15.9, 15.9.1 

Component : CA PPM SAAS DATA WAREHOUSE

Resolution

  • Till the attribute is available please use clarity schema for reporting 
  • Additional attributes under Roadmap and Roadmap attributes are planned for future releases and for any question please join the Clarity PM office hours 

Attachments