How to retrieve custom attributes using Rational insight report?
3 answers
Hi Valli,
Custom attributes are grabbed by default if you are using the RTC 3.x ETL. You can find them in the report package in the ODS Request Area. Look for "Request String Extension", "Request Integer Extension", etc. Which extension to use will depend on which type of attribute you are looking for. The "Name" value will have the custom attribute name, and the "Value" field will contain the value for your attribute.
If your custom attribute is an enumeration, you'll also need to look at "Request Enumeration". For Request Enumeration, the External Id field will map to the Request String Value field, and the Literal Name field maps to what the end user sees in the enumeration field in RTC.
It can be a little confusing until you play around with it some, but I hope this helps
Custom attributes are grabbed by default if you are using the RTC 3.x ETL. You can find them in the report package in the ODS Request Area. Look for "Request String Extension", "Request Integer Extension", etc. Which extension to use will depend on which type of attribute you are looking for. The "Name" value will have the custom attribute name, and the "Value" field will contain the value for your attribute.
If your custom attribute is an enumeration, you'll also need to look at "Request Enumeration". For Request Enumeration, the External Id field will map to the Request String Value field, and the Literal Name field maps to what the end user sees in the enumeration field in RTC.
It can be a little confusing until you play around with it some, but I hope this helps
Hi Jackie,
Thanks. Report package here means the default one (or) does it apply to custom-created ones as well?
I have one more doubt w.r.t the report design. I need to plot owner against number of issues/risks held as welll as number of open issues/risks. But the problem that i face is:
under "Change mgmt" section -> there is "resource" instead of owner and the "total requests" count works if i plot with resource - but data is not same as owner. But if i plot against "owner name" from within total request metrics, its taking the whole count for every user. I think i am missing something w.r.t joins...i am designing using report studio and unable to find an easier way to do this.
Thanks.