Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 26540 Views
- Blue Cross Blue Shield Association, TCS, I also Faced
- E-Mail Answers
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
What is a Query Subject?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
-----------------What is Direct and Conventional loading?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What are the considerations regarding performance kept in mind while setting up cognos?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
What do you understand by ‘ibm predictive maintenance and quality’?
Why need staging area database for dwh?
What are all types of Batches?
What is the difference between Standard and Metrics folder?
What is cognos reporting tool?
What is the difference between static and dynamic conditions?
What are the types of hierarchies?
what do u mean by bridge group? where we r using this one?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
