RTC Report: Joint Data Set without a common parameter
hello guys!
i need to create a report with a data set that combines the WORKITEM_STATE_EXTERNAL_ID of the Star_remote_snapshot with the WI_NAME of the LIVE_CNT Table of the Workitem_snapshot... As these two different data sets of different data sources lack a common parameter to combine the sets, I struggle creating a joint data set between them... Is this even possible?
Thank you a lot!
i need to create a report with a data set that combines the WORKITEM_STATE_EXTERNAL_ID of the Star_remote_snapshot with the WI_NAME of the LIVE_CNT Table of the Workitem_snapshot... As these two different data sets of different data sources lack a common parameter to combine the sets, I struggle creating a joint data set between them... Is this even possible?
Thank you a lot!
One answer
Hi Melissa, I am not a specialist of report, but have you checked this article http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part2/index.html?
It introduces a way to combine two data sets with using a "link" data set. I am guessing this idea may help you...