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

Why do we create shortcuts in framework manager

4 Answers  


What are all the different types of prompt in cognos?

0 Answers  


what is mean by cognos powerhouse?

1 Answers   TCS,


what is an sid (surrogate key)?

4 Answers   IBM,


suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?

2 Answers   Mind Tree,






what is drill down and slicing and dicing what are the difference between them?

5 Answers   IBM,


what is tabular set? how can you break the report?

1 Answers   Syntel,


HOW TO DEVELOPE THE DRILLTHROUGH REPORTS?

4 Answers   IBM, TCS,


What is Parametermap?

2 Answers  


How to create a dynamic column name in Cognos?

6 Answers   Aditya Birla, Polaris,


what use of surgate key in project

3 Answers   HCL, TCS,


How to create Events?

1 Answers  


Categories