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 the procedure for scheduling conditional rendering?

2002


What is a Folder?

679


What is looping and how to avoid it in framework manager?

661


Can you define cognos powerplay?

629


What is meant by drill down?

522






Can you define snapshot?

553


When we save a report in report studio with what extn it save?

652


Define datastores in cognos?

556


Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

1750


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?

2082


Can you define cognos impromptu?

624


Diff b/w Crossproduct and Outerjoin?

1813


How can we create a dynamic column name in cognos?

535


How can create users and permissions in cognos?

559


hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

1938