what is the meaning of aggregation and rollup aggregation?
Difference between layout calculation and query calculation?
How do you hide the rows that have null values?
why we use query studio? what is the use of query studio
compared to report studio?

Answer Posted / pooja

Aggregation : How query data aggregates data item at lowest
level of detail.
Rollup : Specifies how query data aggregates group value for
data item.
Hidng rows: by applying filter.

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

2155


What is the use of report studio?

620


Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1483


What is the difference b/w macros and prompt?

602


How can I schedule reports in cognos?

608






what is a prompt value in report studio and variables ?

2175


please please give me some banking calculations in framework manager.

1667


What are query items?

586


Can you define drill across?

571


1. Explain your project.

1597


What is Metrics designer?

600


dumps needed ASAP for - C2020-180 Cognos IBM Certification

1825


what is the role of cognos comsultant?what actually it means?pls reply

1888


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...

3522


How to Reset Pagenumbers in one report.

2221