Which sql (native sql or cognos sql) will the query hit for processing?

[yogeswari]

Hi,

"When a data item is dragged and dropped into report, after the default query generated, then which SQL will the query hit for processing either native sql or cognos sql?


The above which i did not get correct answer after many googling. So please clear my doubts as your information would be really greatful.

Thanks,
Yogeswari.

[Raghuvir]

Hi,

"When a data item is dragged and dropped into report, after the default query generated, then which SQL will the query hit for processing either native sql or cognos sql?


The above which i did not get correct answer after many googling. So please clear my doubts as your information would be really greatful.

Thanks,
Yogeswari.

Cognos SQL is a database agnostic form of the query which is translated into the Native SQL which is then sent to the database. Some operations may not be supported by your database so occasionally only part of the Cognos SQL can be translated into the Natvie SQL. In this case you will have part of the query processed at the database and a later portion processed at the Cognos server according to the Cognos SQL statement.

[ravimahazan84]

It's depends in which processing you are asking this.if its database end its Native sql and for content store end its cognos sql.

[barrysaab]

Does it means Cognos sql is translated  to native sql  ,Then it is executed.I always assumed, it is native sql that hits the database.
Can someone please confirm.Thanks in advance