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. |