These are few Interview questions i faced.I hope to get
help here.
1.Can we convert a Crosstab to List?
2.How do you approach and who tells you what exactly the
way report has to be developed so that i meets the client
requirements?
3.Can we link the List and Chart thats created in the same
report?
4.Where do you edit sql in cognos8 ?
5.What is the difference between native sql and oracle sql?
6.What is the difference between MOLAP and ROLAP?
7.What is the use of BI in datwarehousing?
8.What are set functions?
9.How do you test a report?
10.What are the variables you find in toolbox?
11.How many types of filters are there in cognos8?
All the answers r welcomed .U can reach me at
vinod.davala@gmail.com
Answer Posted / venkatesh
1.its possible to convert crosstab tolist
because it will contain rows,colums and measures
sameinformation we will convert into list
2.based upon reportrequirement templet only we prepare
reports which repots the client want
3.yes we will link the list and chart using drillthrough
4. we edit sql in properties pane
5.MOLAP used to for cube development
rolap used for relational operations
6.BI datawarehousing used for bussiness opertions analysis
7.to running a report or validate a report
8.group filter,summery filter.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is a Cube?
What are the ways to import data into catalog?
----------------Diff b/w Dimensional modeling and Relational modeling?
Can you define transformer?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
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?
Write types of folders present in cognos?
Can you define drill down and drill up?
What are the other methods working as deployment functionality?
5. Which type of report you build more, list, crosstab or chart and why?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
what is online view?
What is a Folder?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
Tell me about Dnamic and Static Dashboards?