What is the disadvantages of using Database functions
instead of using Cognos Functions in Report studio?
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 |
While running the reports how can we hide totals if the users doesnot requie it?
What is the difference between macros and prompt?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
Can you define folder?
wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?
6. Which of them will increase the performance?
What are the Macros?
what is cardinality that you can give to employee and department query subjects in framework manager?
how u will design the report if the objects are available
What is an open session command in cognos connection?what is it meant for?
if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?
what is filter?give me one example that you created a report in your project?