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?
- 7 Answers
- 24710 Views
- Blue Cross Blue Shield Association, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / thakkalapelly anil
cognos sql is most prefarable because it can fetch the data
from multiple databases.
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / akhilesh pyasi
Cognos SQL because it improved performance of query by
converting simple sql to optimum Cognos Sql.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
(1)The FWM uses cognos SQL as a default SQL to create and
edit query subjects.
(2)cognos sql supports SQL 99 standards, which are used in
modifying the query subjects.
Where as
(1) The native SQL is the SQL the database uses such as
oracle,sql secver etc.
(2) A cognos query definition engine (QDE) convert the
cognos SQL into a native SOL which will be submitted to the
data source to query the data.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sridhar
It depends upon the requirement of Report as well database .
If report wants to show from the different database cognos
sql is most prefarable because it can fetch
from multiple databases.
also for calculation as well other complicated business
rules Cognos sql its preferred.
also we can hide the underline tables as well database
source.
Advantage of native SQL will be no need of metadata .
We are passing the Query to native to handle it.
In my experince column name was case senstive if it changes
it was throwing error - isnt wiered :-(.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / venu
cognos sql bcz cognos sql only adheres sql99 rules and work
with multiple datasources and query performance much
fasterthan native sql if we are using data from single
datasource native sql is preferable
| Is This Answer Correct ? | 1 Yes | 1 No |
Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos
How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
What is difference between page break and section report?
---------------Can we use more than 1 Fact table ?
what is fact less fact give me proper example?
What is Render Variable? where u can use?
How to write a condition for multy select in conditional formatting... Eg:- i added list,crosstab, barchart, columchart, guagechart, pie chart for value prompt by using static choices.. if i select multiple that all the things has to be display.. this is requirement how is possible to display..
How many reports did you create in your project?
Define the slice and dice?
in reportnet how u burst the reports for every 5th day, 10 th day, 15 th day, 20 th day
What is the difference between Standard and Metrics folder?
Teradata 
