Reportnet - Don't use Cognos Query Engine

[benhurtec]

Hi,

How can we configure Reportnet if we only want the SQL code to be processed by the database server

We have a 1,5Tb data warehouse and the DB server is more efficient than the Apps Server.

We will be installing ReportNet soon and we want to do it right for the future.

Does anybody know what we can do to achieve this?

 

[Draoued]

When you are creating the Package in FrameWork manager , you can defined for each DATASOURCE the processing capabilities.
You have basically 2 options : DatabaseOnly or LimitedLocal.

As far as I know that the only place where you define the Query Processing place.