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?
- 7 Answers
- 24190 Views
- Cap Gemini, iFlex, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / upendra raju
plz give an answer for this questions.
+91-9885186575
| Is This Answer Correct ? | 7 Yes | 8 No |
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 snapshot ?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
Whrer u can save the Report net documentation in our local system?
Can you define set to be cardinality?
What are the different ways of adding data in Transformer?
What is value prompt limitations while creating report? What is select and search prompt?
what is the difference between cascading prompt and drill-thru
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
What are slice and dice?
Define query studio?
write the sql query to display 5th and 10th row in a table?
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
Teradata 
