What are differences between Reporter report and Explorer
report?
Answers were Sorted based on User's Feedback
Answer / mohan potla
Many differences are there..
ER is default report type. which creates the report by
taking first two dimension row and cols.
RR gives blank report ,where u can add u r dimension of u r
interest.
Use ER to replace existing categories in an Explorer
report,
| Is This Answer Correct ? | 3 Yes | 0 No |
Explorer Report
Use - To explore one dimension at a time
Default Layout - A crosstab structure with summaries on
rows and columns
Moving categories accross - replaces rows and columns
Drill-down behaviour - Drill down displays the next value
going down the categories hierarchy tree
Drill-up behaviour - Drill up displays the next value going
up the categories hierarchy tree
Calculation - Columns and rows totals calculated
automatically
Reporter Report
Use - To combine and mix various dimensions in rows,
columns and layers
Default Layout - A Blank report which is completely
customizable and can be tailored to users needs
Navigation.
Moving categories accross - adds rows and columns
Drill-down behaviour - Drill down adds more detailed values
next to the parent category
Drill-up behaviour - Drill up removes values from the child
categories
Calculation - Columns and rows totals not calculated
| Is This Answer Correct ? | 0 Yes | 0 No |
What is snapshot ?
can we create a chart without measure
Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?
Tell me about Schemas?
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?
What are slice and dice?
Define metrics studio?
how to find the rank in report studio? i need steps for this question.
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
-------------What is a Conformed Dimension?
how will optimiz the performance of sql in FM ?
what type of charts we create mostly in realtime? plz help