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
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
Can you explain new content durability?
Can you explain model durability?
What is meant by junk dimension?
What are all types of Batches?
How to apply securities for reports in cognos connection?
What is difference between primary key and unique key constraints?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
whats the difference between previous version of cognos and cognos 8 BI?
Define datastores in cognos?
--------------Diff b/w ODS and OLAP?
how can I test reports in cagnos?
What is meant by alternate drill down with ex?
What do you understand by the term 'aggregate advisor?'