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


Please Help Members By Posting Answers For Below Questions

what are the names of the reports that you prepared?

630


What is the complex report you faced in real time?

1736


what are the dimensions that you have in your current project?list them?

1604


What is main difference mapplets and mapping?

572


in u r data u having duplicates how to fetch the latest data in our report?

4618






What is a Pivot?

548


hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

1783


If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

1709


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

1699


what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

577


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1537


write a query to display the departments with no employee?

1555


i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1562


how to connect datamarts

2378


------------------What is Inline Query?

1794