what is the difference between aggregation and role up aggregation ?
Answer Posted / suresh
Hi,
Aggregation is normal aggregation like we do in SQL
query(Total,Avg,Count,Max,Min,Sum).
Rollup aggregation is at the end what should do for the
total report.
for example below:
Country Quantity
India 10
India 24
Singapore 6
Malaysia 4
when you group this report Aggregation for India
34,Singapore 6,Malaysia 6 and Rollup aggregate for this
report will be 44 calculated
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
Can you define query studio?
What is the importance of having monitor service in cognos?
What is Bitmap Index?
What is the advantage of using shortcuts?
What is the complex report you faced in real time?
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate what are the filters in framework manager and report studio? What is drill down and slicing and dicing whats the difference between them? what is the difference between filter and condition? Diff b/w Crossproduct and Outerjoin? hi, this is harish. i had finsihed cognos course recently.can
some one help in the area of project explination, interview
questions,real time scenarious....this is my maild id
nanagupta907@gmail.com What are the message flows? What is the difference between set functions and filter
function in dimensional data?