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 |
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
What you mean by drill across and what is the difference between drill through, drill across?
how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls
suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?
How to pass parameter value into html design page? (That is YOU Create a html page and use that page in your cognos 8 report header.take <html item> my question is how to use parameter value in the html page .)
4. How many dimensions did you use in your reports?
How can we improve performance in report studio level?
------Diff B/W DrillThrough and master and Detailed Report?
What r the names of the reports that you prepared?
What are all the types of indexes in Cognos?
what is the different between primarykey and surrogated key.. why we are going for surrogatekey...
architecture of cognos8