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 / 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 |
Post New Answer View All Answers
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
What is Metrics designer?
What is the metric store database?
What are the two types of framework manager?
Can you define cognos impromptu?
Can you define report item?
Name the types of report?
What are the components of report net?
Cleared COG-112 with 100% score today. What next certification should i go for?
What is the difference between ‘macro’ and ‘prompt?
what is requery in cognos?
What is cognos powerhouse?
Why are meta service important then other services?
What is the model filter?
---------------Describe OLAP Reporting and RDBMS Reporting?