What is the disadvantages of using Database functions
instead of using Cognos Functions in Report studio?



What is the disadvantages of using Database functions instead of using Cognos Functions in Report s..

Answer / naresh

1)Its permitted to Perticular Database(like Oracle ,Sql
Server ,DB2 ..)so those function wil work until you are
using that databases ,

If you are using cognos functions even after you shifted to
another database also no need to change them.

2) Performance will be slow every time it will hit the
database and validate them ,so performance will be slow ,

If Cognos functions then once data extraction into buffer
area then it wil perform operations one time hitting of
database .

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Cognos Interview Questions

I have to apply drill through 1,2,7 out of 10 in order method, how can i do?

1 Answers   Satyam, TCS,


What are the ways to import data into catalog?

0 Answers  


What is defined as catalog and types of catalogs in Cognos?

0 Answers  


how u will design the report if the objects are available

0 Answers   Ness Technologies,


How many fact tables you have in your project?

1 Answers   HCL,






What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.

3 Answers  


What are the roles defined by cognos platform?

0 Answers  


what is the role of cognos comsultant?what actually it means?pls reply

0 Answers  


What is drill down and slicing and dicing whats the difference between them?

0 Answers  


New coloums are added in database, then how you know in report level

0 Answers   Accenture,


what is a Galaxy Schema?

2 Answers   IBM,


What is model filter and query filter?

2 Answers   Wipro,


Categories