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
- 23121 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 TRAP in Framework manager?What's the use of TRAP? Where We are using this?
when can i use the STAR Schema and SNOWFLAKE Scgena
What is the report studio?
what is loop in frameworkmanager ?
------------ Diff b/w MemberCaption and MemberDescription?
what are the special features in cognos reportnet?
10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?
How to move reports one server to another server?
What is the difference b/w macros and prompt?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
What is meant by grouped star schema
How can I schedule reports in cognos?
Teradata 
