CLM Datawarehouse - Request Type in Request Metrics
We have multiple project areas using the same process template.
When we create a view in Query Studio (using default Reporting Data Model), selecting measure Change Management > Request Metrics > Total Requests and dimension Change Management > Request Metrics > Type, if we filter by type, each type appears many times on the list.
Investigating, we realized that ETL process associates a new ID for each Workitem Type of each Project Area. So we cannot filter by workitem type.
Anyone knows a workaround?
Thanks in advance.
When we create a view in Query Studio (using default Reporting Data Model), selecting measure Change Management > Request Metrics > Total Requests and dimension Change Management > Request Metrics > Type, if we filter by type, each type appears many times on the list.
Investigating, we realized that ETL process associates a new ID for each Workitem Type of each Project Area. So we cannot filter by workitem type.
Anyone knows a workaround?
Thanks in advance.