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
What do you understand by the term 'dynamic cube'?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
how to test reports in cognos?
How to select multiple values from type-in prompt?
Define metrics studio?
What are the steps to import the two data sources in framework manager?
What are the other methods working as deployment functionality?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
is cognos 7 is better than cognos 8
Can you define drill down and drill up?
----------------------What are the User Securities?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
How to apply securities for reports in cognos connection?
What is defined as data mining?
How to join multiple db in catalog?