i have a sales project interviewe asked tel me the how many
facts&dimensions used in ur project.
Answer Posted / sathish
Hi,
Dimensions table is something that is called by the fact
table, so if you take the star schema for example the fact
is the center of the star schema and dimensions are like
the wings like of things,
so fact are usually the only one, the dimensions might vary
depending upon the requirements and needs'
feel free to contact any queries,
sathishcnpt.938@gmail.com
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
What do you understand by ‘ibm predictive maintenance and quality’?
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?
------------------What is Inline Query?
Explain what is the difference between native sql and cognos sql?
What are the different types of important services used in cognos?
what is online view?
What is defined as Query studio?
What are all the advantages of Cognos?
What are the components used in web tier?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
What is meant by junk dimension?
Tell me about Dnamic and Static Dashboards?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
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