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?

Answers were Sorted based on User's Feedback



what is the meaning of aggregation and rollup aggregation? Difference between layout calculation an..

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

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation an..

Answer / malathi

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 ?    10 Yes 3 No

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation an..

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

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation an..

Answer / sri

To hide the rows which has null values use the Zero
suppresion for rows...

Rgds,
Sri

Is This Answer Correct ?    2 Yes 1 No

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation an..

Answer / upendra raju

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

Is This Answer Correct ?    7 Yes 8 No

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation an..

Answer / neelima

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 ?    4 Yes 5 No

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation an..

Answer / sp323

TO HIDE COLUMNS WE CAN USE RENDER VARIABLE TOO.

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Cognos Interview Questions

using of matric studio we can developed to scorecard ... what is the meaning by scorecords

1 Answers  


How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?

5 Answers   CTS,


What are the types of studio present in Cognos?

1 Answers  


Diff b/w surrogate Key and Primary Key?

2 Answers   Cap Gemini,


Can we install cognos on windows 7?

4 Answers  


why we r using report studio in webbased only and fm windows based only

1 Answers  


Give the advantages of cognos?

1 Answers  


What is the information present in the cognos configuration file?

1 Answers  


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

0 Answers  


What is cognos connection?

1 Answers  


can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

1 Answers  


how u provide security to reports??how u provide security to packages ?

5 Answers   Wipro,


Categories