what is the meaning of aggregation and rollup aggregation? Difference betw

Advertise your Business Here

Refer this Site

Login | Sign Up


	Ask Questions on ANYTHING, that arise in your Daily Life at FORUM9.COM

Categories >> Software >> Data Warehouse >> Cognos

Teradata Interview Questions

Business Objects Interview Questions

Cognos Interview Questions

Informatica Interview Questions

Crystal Enterprise Suite Interview Questions

Actuate Interview Questions

Ab Initio Interview Questions

Data Stage Interview Questions

SAS Interview Questions

Micro Strategy Interview Questions

ETL Interview Questions

Data Warehouse General Interview Questions

Question

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?

Question Submitted By :: Guest

I also faced this Question!!

Rank

Answer Posted By

Re: 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
# 1

plz give an answer for this questions.
+91-9885186575

Is This Answer Correct ?

1 Yes

1 No

Upendra Raju

Answer
# 2

Layout calculations are used to get the runtime information 
into the report for eg: date, no of pages etc.
Query Calculations are used to perform required logic used 
in the report for eg: calculation the revenue, sums etc.

Using Qery Studio we create simple and adhoc reports where 
as using report studio we create complex and business 
reports.

Is This Answer Correct ?

2 Yes

0 No

Malathi

Answer
# 3

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 ?

2 Yes

0 No

Answer
# 4

you can hide the rows having null values by applying 
conditional formatting as when you find null values in rows 
make the box type none in the properties

Is This Answer Correct ?

2 Yes

1 No

Neelima

Question	Asked @	Answers
Other Cognos Interview Questions


how will optimiz the performance of sql in FM ?	Infosys	1
How can we improve performance in framework manager level?	Wipro	2
What is the difference between filter & Condition?	IBM	1
Column level security in report		3
What are the different ways of adding data in Transformer?		1
Difference betwween cognos report net architecture and cognos8 architecture		3
Why we take so long time to display date prompt before displaying a report? How can we reduce the time?		1
Can we install cognos 8 on windwos xp sp3.......(and i like to use data base as sql server 2000.....is it preferable?)......... pls let meknow... thaks in advance...		1
how to Explain a complex report at the time of interview ? please post the answer very urgent?	HSBC	2
pls any body give the cognos 8 versions release year.		2
What is the use of Excel files in Cognos8?		1
suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?		1
I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?	SAIC	2
cognos is holap or molap or rolap	Cognizent	4
what is exact catalog size?		3
plz anybody help me, how many reports we can create in one project?, and what are the names?in real time project at first what we will do?		1
How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?		3
suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?		1
What are the steps involved in migrating CRN enviroment to Cognos 8?	BMW	2
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS	iFlex	1

For more Cognos Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com