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
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 tabular set? how can you break the report?
What is the metric store database?
Can you define a datastore in cognos?
-------------------What is StarShema?
how to perform single sign in cognos by using url?
Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.
9. What was the most complex type of report you dealt with?
what is log in cognos?
How can we change any header or footer for a group of reports
1 Answers Satyam, Tech Mahindra,
I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!
what is the difference between querystudio in reportnet and cognos8
How can I disable the drill-down for the last level of my dimensional hierarchy ????