It's all about the answers!

Ask a question

CLM Datawarehouse - Request Type in Request Metrics


Luana Santos (112) | 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.