COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: BiliBoy on 31 Aug 2012 01:33:04 PM

Title: Layout component reference in report studio
Post by: BiliBoy on 31 Aug 2012 01:33:04 PM
does  too many layout component references in report makes report perfomance very slow?  if it is then what could be the reason ? how to minimize report execution time with too many layout component references?
Title: Re: Layout component reference in report studio
Post by: blom0344 on 05 Sep 2012 04:20:06 AM
Just an idea:

Copy the report and strip it regarding layout component references. Then time both reports with the same input. Make sure to time after multiple executions otherwise  database optimizer and caching can influence the comparison..
Title: Re: Layout component reference in report studio
Post by: bdbits on 05 Sep 2012 01:57:42 PM
If the layout component references do turn out to be the problem, you could try changing the layout component property "Embed".  If you set it to "Reference" - the default - it will go find the component source each time the report is run. If you change it to "Copy" it will keep a copy in the target report, however if you change the source you will need to right-click the target's layout component and select "Update Component Copy".