what is difference btw summary filter and detail filter,
plz explain with example
Answer Posted / manju
Before aggregation we can use detail filter and After
aggregation we can use summery filter.
For example:There is one calculated query item values like
10
20
30
40
50....likewise.
if you apply detail filter we can get every indudual values.
Fom above example we can get 10 or 20 or 30 or 40 or 50.
If you apply summery filter we can get total of values.From
above example we can get 150.
I think it is correct.If it is wrong please let me know.
| Is This Answer Correct ? | 10 Yes | 18 No |
Post New Answer View All Answers
New coloums are added in database, then how you know in report level
What is Metrics designer?
What are the components used in web tier?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
what is hints in cognos and where we use it.
what are the dimensions that you have in your current project?list them?
what is the difference between list report and crosstab report?
What are types of batch available in cognos?
Write various indexes used in cognos?
can you tell me what are the dimension tables are used in project
What is meant by alternate drill down with ex?
what is stitch query in reportnet?
Define olap designer?
Mention the difference between ‘macros’ and ‘prompt’?
how to connect datamarts