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

What is the function of model design accelerator?

0 Answers  


if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?

2 Answers   CTS,


I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!

3 Answers  


how you create security to reports?

0 Answers   IBM,


how u create security to reports ????

10 Answers   iFlex, iGate,






What is the enterprise class platform architecture of cognos 8?

0 Answers  


What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?

0 Answers   IBM,


how can you get the errors in job? when loops are araised we get error?

0 Answers   Syntel,


What is Correlated sub-query? Please explain

1 Answers   Target,


-----------What is member Description?

2 Answers  


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

0 Answers   Accenture,


What is stitched Query?

5 Answers  


Categories