Business Objects interview question

1. Explain detail objects? - Sol: Detail objects are attached to dimensions, one cannot drill on details nor link on details when linking multiple data providers. While Customer ID would be a dimension, customer name, address, phone and soon should be details.
2. What is BOMain.Key? - BoMain.Key file contains the information about the repository site i.e it contains the address of the repository security domain.
3. What is Business objects Repository? - it is nothing but metadata.
4. What is domain? How many are there in a basic setup? What are they? - Domain is nothing but logical grouping of system tables, There are three domains usually in a basic setup, They are Secure, Universe, Document. Business objects are sometimes called domain objects (where the word domain means the business), and a domain model represents the set of domain objects and the relationships between them.
5. When is the Repository created? - In 5i/6i versions after installing the software, whereas in Xi version a repository is created at the time of installation.
6. Can we have multiple domains? - Yes. (Security domain can not be multiple).
7. How do you restrict access to rows of a database? - In XI version it can be done by using row-level security in designer module whereas in 5i/6i it is done by supervisor.
8. What is a category? - It is nothing but grouping of certain entities.
9. What is a Universe? - It is a semantic layer between Database and the designer used to create objects and classes. (It maps to data in Database).
10. What is an Object? - It is an instance of class, its nothing but an entity.
11. What do you mean by Object qualification? - Object qualification represents what kind of object is that, usually we have three types of object qualifiers they are measure, dimension, detailed.
12. What is the size of data base? - In general it will be anything between 4-8 Terabytes.
13. What is a loop? How can we overcome? - Loop is nothing but a closed circular flow; it can be overcome by making use of Alias and Context.
14. What is a join? Explain different types of joins? - Join is used to link to tables depending upon the data requested by the user, Usually we have Inner Join, Outer Join, Left Join, Right Join, Full Outer join.
15. 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.
16. What are Alerter, Filters, Breaks and Conditions? - Alters are nothing but they are used to draw attention to a block of data by highlighting. Breaks are nothing but grouping the data without any change in the format. Condition is used to retrieve data which meets certain criteria. Filters are used to get necessary data.
17. What is the difference between master-detail and Breaks? - In break common fields are deleted (here in this case the table format is not changed) whereas in master-detail , we declare certain entity as a master to get the detailed information or report in this case the table format is changed.
18. What is metrics? - Metrics are a system of parameters or ways of quantitative and periodic assessment of a process that is to be measured; these are used to track trends, productivity.
19. What is a Set? - Its nothing but grouping of users.
20. What is the use of AFD? Where it can be stored? - used to create dashboards. It can be stored in repository, corporate or personal.
21. what is the source for metrics? - measure objects.
22. Why do we need metrics and sets? - Metrics are used for analysis and Sets are used for grouping.
23. Is there any bug in 6.x? - In earlier version of 6.0 they had, but 6.5 is the best version with out any bugs.
24. What are the general issues in migration process? - Alignment, performance.
25. What is the use of BO SDK? - Bo SDK main use is to suppress “no data to fetch” using Macros.
26. How can we improve performance? - By making use of Aggregate tables.
27. Analysis in BO? - Slice-Dice and Drill analysis.
28. How can you check the integrity? - By making use of Check integrity button.
29. What are Universe parameters? - Name of the universe, description and RDBMS connection, size and rights.
30. Types of Universes? - Simple and Complex.
31. What is the use of BCA? - BCA is used to refresh and schedule and export and save as.html,.rtf,.xls ,.pdf.