what is the difference between count and running-count
functions?
Answer Posted / beckham
count(C) - it counts the no of values of a given item.
running-count(RC) - it sequentially numbers the rows being
displayed.
C RC Data Item
5 1 aaa
5 2 bbb
5 3 ccc
5 4 ddd
5 5 eee
| Is This Answer Correct ? | 23 Yes | 3 No |
Post New Answer View All Answers
How to join multiple db in catalog?
What are the advantages of cognos?
What are all the components of Report Studio?
Can you define report item?
What is model?
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...
Explain what is the difference between native sql and cognos sql?
how u will determine the performence tune will occur either in report or system
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
What is a dimension?
What is the advantage of using shortcuts?
how to perform single sign in cognos by using url?
What are products of cognos?
What is the model filter?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?