What is the disadvantages of using Database functions
instead of using Cognos Functions in Report studio?
- 1 Answers
- 5021 Views
- Cognizant, Niteo, SacSoft, I also Faced
- E-Mail Answers
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
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
How Metrics Studio is better than Report Studio?
what is requery in cognos?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
What is Fullouterjoin?
What are query items?
is there any difference between operational database and data base?if yes what r they?
What junk dimension contains?
What is difference between informatica power mart and power center?
Can you explain a cognos controller?
How can I schedule reports in cognos?
what are the dimensions that you have in your current project?list them?
What are the types of studio present in Cognos?
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?
What is called a slice?
