It's all about the answers!

Ask a question

CLM Datawarehouse - Request Type in Request Metrics

Luana Santos (1122) | asked Mar 23 '15, 5:22 p.m.
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.

Be the first one to answer this question!

Register or to post your answer.