Business Intelligence Interview Question and Answers

57. How do you design a universe?
  The design method consists of two major phases.
  • During the first phase, you create the underlying database structure of your universe. This structure includes the tables and columns of a database and the joins by which they are linked. You may need to resolve loops which occur in the joins using aliases or contexts. You can conclude this phase by testing the integrity of the overall structure.
  • During the second phase, you can proceed to enhance the components of your universe. You can also prepare certain objects for multidimensional analysis. As with the first phase, you should test the integrity of your universe structure. Finally, you can distribute your universes to users by exporting them to the repository or via your file system.
 
Your Name Your Email-ID
Your Answer
58. How can you check the universe?
  Using check Integrity, u can check the universe.
Go to Designer, Tools -> check Integrity
 
Your Name Your Email-ID
Your Answer
59. What is Business Intelligence 80 / 20 concept?
  In a business Intelligence environment 80% of development time is allocated to OLAP interface designing, 20% of time allocated to Report development.
 
Your Name Your Email-ID
Your Answer
60. What are Linked Universes?
  If the data provided is from two different data providers then we can link those two universes, such type of universe is called Linked Universe.
 
Your Name Your Email-ID
Your Answer
123456789101112


131415 Page 15 of 15