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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what is log in cognos?

666


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

1955


Can you define confirmed dimension?

636


How to generate cubes in cognos?

574


What is zero-foot print?

598






------------- How to identify the Revenue Column in Report?

1823


What is a Cube?

688


explain how to create powerplay reports?

612


Can you define cognos powerplay?

637


We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2084


How can you link a query to a data container manually in Report Studio?

1932


Cleared COG-112 with 100% score today. What next certification should i go for?

1419


Give the advantages of cognos?

581


How can create users and permissions in cognos?

563


WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

5985