Report studio has two SQL tabs one native SQL and another
one cognos SQL which one is get more preference? which one
we need to consider?

Answer Posted / krishna tammana

Cognos SQL and Native SQL are two different types of SQL
generated by cognos tool. Native SQL is sub set or same as
Cognos SQL.
Native SQL contains only the functionality that got
executed at database end, apart from this Cognos SQL will
have the Locally processed logic as well.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

1595


What is called a slice?

575


what is log in cognos?

660


in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1417


what are the names of the reports that you prepared?

622






Can you define cognos powerplay?

627


What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4076


Explain the different types of views used in cognos.

506


What DB View and Bus View?

1542


--------------Diff b/w ODS and OLAP?

2752


What is the difference between set functions and filter function in dimensional data?

2510


Define catalog in cognos and write its various types?

615


Define cognos report net?

559


How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

1551


Can you explain new content durability?

566