BIRT Join Dataset is extremely slow and so switched to Hash
Hello,
I was trying to get a dataset that can show a Epic, Story and Links joined to result in a one dataset. When I did use the BIRT Join Dataset It was extremely slow as Links table has no filter specific to a project. So I went in the direction of creating a hash and try to use scripted dataset. It doesn't see to render the data in the table that is added to the layout. Can someone help me with the issue I am facing.
version: RTC 4.0.x
Thanks
RK
I was trying to get a dataset that can show a Epic, Story and Links joined to result in a one dataset. When I did use the BIRT Join Dataset It was extremely slow as Links table has no filter specific to a project. So I went in the direction of creating a hash and try to use scripted dataset. It doesn't see to render the data in the table that is added to the layout. Can someone help me with the issue I am facing.
version: RTC 4.0.x
Thanks
RK
Comments
Donald Nong
May 06 '16, 1:56 a.m.Your problem description lacks some details. It seems to be related to the huge number of records in one data set being joined, then how are you going to filter the joint table if the base tables cannot be filtered (as you said)? Scripted dataset can be quite flexible but again without details no one knows what you have done.