COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: shri on 30 Oct 2007 07:12:04 PM

Title: Formatting query items..?
Post by: shri on 30 Oct 2007 07:12:04 PM
hi all,

Formatting query items is better in Framework Manager or Report studio..? is that affect the performance of report (speed).

Thanks heaps
Title: Re: Formatting query items..?
Post by: praveennb on 30 Oct 2007 09:37:11 PM
I have not noticed any performance increase if you formatted your query items in FM

but it helps to develop reports faster as the query items will have formatting applied. I prefer to apply the formatting in the FM model.

Title: Re: Formatting query items..?
Post by: nuknsltnt on 31 Oct 2007 12:14:04 PM
Although a bit different from your question.

In some cases you have to format in FM, eg., for pass-through sql query items.
Title: Re: Formatting query items..?
Post by: shri on 31 Oct 2007 07:13:44 PM
Quote from: BI007 on 30 Oct 2007 09:37:11 PM
I have not noticed any performance increase if you formatted your query items in FM

but it helps to develop reports faster as the query items will have formatting applied. I prefer to apply the formatting in the FM model.




Thanks bi007
Title: Re: Formatting query items..?
Post by: shri on 31 Oct 2007 07:16:22 PM
Quote from: nuknsltnt on 31 Oct 2007 12:14:04 PM
Although a bit different from your question.

In some cases you have to format in FM, eg., for pass-through sql query items.

Thanks nuknsltn