Difference Between Limited Local and Database Only

[diasbrad]

Hi Friends,


Could anyone explain to me with a suitable example the difference between Difference Between Limited Local and Database Only. And how will it effect the performance of a report.

Thanks in advance for your help.

Thanks & Regards
Brad

[Raghuvir]

Hi Brad,

Processing
Specifies whether the query engine will pick up a minimal amount of processing. Local processing only occurs if the database cannot handle the load. This property applies only to dimensional, or OLAP, data sources.

Specifies whether the IBM® Cognos® report server picks up a minimal amount of processing. This property overrides the corresponding governor in the model. If unspecified, the value of the governor in the model is used. This property applies only to relational data sources, unless you use the dynamic query mode.

Database only specifies that all query processing is performed on the database, and none is performed and cached by the IBM Cognos report server. The query executes successfully only if all query operations can be performed by the database.

Limited Local specifies that little, or possibly none, of the query processing is performed by the Cognos report server. Local processing only occurs if the database cannot handle the query.

When using the dynamic query mode, this property applies only to SAP BW data sources and the Limited Local option is not supported. Database Only specifies that little, or possibly none, of the query processing is performed and cached by the Cognos report server. Local processing only occurs if the database cannot handle the query. Consider using this option only if your report performance is unacceptable with the default setting, and becomes usable with this setting. Be aware that results may change with this setting; test carefully to confirm that the results are still correct.

Regards