Database Only vs Local Limited Processing (Cognos 8 Reports)

[buyile]

Hi Community

I am looking at understanding the best practise in setting up query processing and I would like to ask what is the difference between the two Database Only or Limited Local.

Also with regards to perfomance which one works best in optimising query perfomance.

Regards

[IceTea]

As simple as it looks like...

Database Only = ALL Queries are processed by the Database. If this is not possible, you get an error and your reports won't worl
Limited Local = Cognos is allowed to process Queries, which can't be processed completely on the Databse, at the local Cognos Machine. This improves the flexibility, but may slow down your things. Sometimes you HAVE to use this Feature, for example when you make Models/Joins with objects from two different Data Sources.