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

how can I test reports in cagnos?

642


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

1888


What are all the types of indexes in Cognos?

722


What is the difference b/w macros and prompt?

602


How do we convert from Numeric to be Words?

2515






Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

1697


What are all the different types of prompt in cognos?

553


5. Which type of report you build more, list, crosstab or chart and why?

1596


can we insert all types of charts in a list report? what r the realtime prompts?

1675


What is model?

562


What is called materialized view?

598


Why need staging area database for dwh?

649


Which studio is used to create reports?

621


Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2147


---------------Describe OLAP Reporting and RDBMS Reporting?

1671