how many facts and dimensions in ur project and query
items,how u deliver ur report to end users..i am going with
fake exp...pls ans me generally what to ans..
Answers were Sorted based on User's Feedback
Answer / ramu
Facts & Dimensions are depends on the project, requirement,Client,.etc.In that scenario you need to 15 Dimensions, 5 facts(That's for general project)
& Coming to delivery method,this is not your part . as a report developer you may develop reports then save it in Public folder that's it.
|Is This Answer Correct ?||6 Yes||2 No|
Answer / 12345
|Is This Answer Correct ?||0 Yes||0 No|
What is Cardinality
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
What is called a slice?
Write a SQL query which should fetch the 5th maximum salary of an employee from the table?
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 email@example.com
what is the use of lock and unlock
How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?
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.
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
Mention the difference between ‘macros’ and ‘prompt’?
The vice president of sales has requested a report that shows sales performance by representatives in each country for year 1998. He would also like to see the performance for reprasentatives in Asia in order to present an award to the top sellers when he visits next month.
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice