Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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.

0 votes


Be the first one to answer this question!

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,507
× 6,131
× 403

Question asked: Mar 23 '15, 5:22 p.m.

Question was seen: 3,386 times

Last updated: Mar 23 '15, 5:22 p.m.

Confirmation Cancel Confirm