----------0Diff b/w Report Functions and Database functions?
Answer / amar
Database functions nothing but Sql functions
Report functions nothing but Cognos functions.
While creating reports, Instead of cognos functions use sql
functions at Maximum. Because performance..
| Is This Answer Correct ? | 3 Yes | 0 No |
how can i test the reports in cognos
What is a scope? can you tell me one example for scope?
..Architectural difference between cognos reportnet and cognos8?
how u provide security to reports??how u provide security to packages ?
How can we create regular dimensions & measure dimensions?
------------------What is Focalpoint?
What is content store?
What is Portal Tab?
we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....
WHAT STEPS SHOULD BE TAKEN BY A REPORT DEVELOPER TO INTERACT WITH THE CLIENT SERVER?
What are the advantages of using cognos sql?
1.How will u link a list to crosstab.?i.e link a pramater in list so that it shows further information in cross tab.? 2.I have different regions,I want region specific logo to be displayed when I run the report.How it is done ? 3.Among Drill through and Master detail relationship which is more effective? 4.How do u hide a column in list report? Ans: In properties,Burn list option-check whichever column u wanna hide. 5.What is Roll play dimension? 6.What is Data Item Value n Parameter value?,What exactly it ll take when select either of them? 7.How many types of filters are there? 8.What will happen if u use detailed filter ?,n what is da result when used on summary filter?