Thanks Prashank , that is a good suggestion we have tried that in couple of our jasper soft reports. But performance gets affected especially if you we try to map a large dataset like the financial transaction tables.
Having said that I want to confirm that mapping in DWH_FIN_TRANSACTION table is incorrect and instead of ID we need to map that table with OBS_UNIT_ID.