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 / x

aggregation is the grouping of data roll-up is the
extension of aggregate caluse.
Query calculation is used for calculated data items and
layout calculation is used for run-time information.we can
supress null values by dataformat
Querystudio is used for simple,ad-hoc reports

Is This Answer Correct ?    17 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between group and associare?

592


How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

2801


Why are meta service important then other services?

583


Why need staging area database for dwh?

639


Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

1751






I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

1528


What is the difference between a cascading report and drill through the report?

733


What are the different kinds of panes included in cognos?

585


Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

907


What is a Folder?

680


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

3505


What is drill down and slicing and dicing whats the difference between them?

544


What are the main services provided by application tier?

561


How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

1552


What is the enterprise class platform architecture of cognos 8?

582