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
Can we test the report other than manual testing?
Can you define bitmap index?
How do we convert from Numeric to be Words?
-------------How you design DWH?
What is a Pivot?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
write a query to display the departments with no employee?
What is set to be Cognos configuration?
How Metrics Studio is better than Report Studio?
Can you define transformer?
can we insert all types of charts in a list report? what r the realtime prompts?
what are the filters in framework manager and report studio?
Can you define query studio?
How create measures and demensions?