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
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
how to connect datamarts
What is Fullouterjoin?
-------------What is Coditional Prompting?
What are all the types of indexes in Cognos?
Why cognos scenario is used?
---------------Tell me about DWH Concepts?
What are the advantages of using cognos sql?
How to publish a package by running Java Script?
What is difference between primary key and unique key constraints?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
how u will determine the performence tune will occur either in report or system
-----------------What is Direct and Conventional loading?
4. How many dimensions did you use in your reports?
How can we create a dynamic column name in cognos?