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 is defined as Cognos Impromptu?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
5. Which type of report you build more, list, crosstab or chart and why?
How to apply securities for reports in cognos connection?
What is the importance of having monitor service in cognos?
what is model and say about process how to create model and how to test model?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
What is difference between data mart and data warehouse?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
Can you define slice?
Can you explain cognos planning?
Can you explain dynamic query mode?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.