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
- 26825 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 defined as catalog and types of catalogs in Cognos?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
hi my name is siraj i want to know cognos queriy language
What is the difference b/w macros and prompt?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
How do you improve the performance of the Cognos Analytics report
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
Write types of folders present in cognos?
how you migrate reports to cognos 8 from previous versions?
----------------Diff b/w Dimensional modeling and Relational modeling?
What is the difference between Standard and Metrics folder?
------------ Diff b/w MemberCaption and MemberDescription?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
New coloums are added in database, then how you know in report level
What is the use of powerplay web viewer in cognos?
