Business Objects is a software company that specializes in business intelligence. Business objects creates components that offer performance management, reporting, planning and query and analysis.If you’re interested in a career in business intelligence, it’s wise to prepare for the kind of questions you might face in an interview. Many of the job descriptions in that field want you to have knowledge of SQL, so take a look at our course on how to Master SQL Quickly. Based from DWBI Concepts, I have compiled some of the most common business objects interview questions that you might see and some pretty good sample answers that you can review before the big day!
1.What is ‘business objects’?
Business Objects incorporates query, reporting, and analysis for business organizations. It allows these business professionals to locate the data in databases from their computers and view the information in a document. It is similar to SQL, but instead of using unfamiliar terms, Business Objects incorporates terms that are used in your specific field, terms that can be understood by everyone.
2.What are the various Business Objects products?
Business Objects products include supervisor, designer, user module, broadcast agent, info view, and business objects software development kit, along with others.
3.What are the advantages of Business Objects over other Decision Support Systems?
Some of the benefits of using Business Objects, as opposed to DSS, are that there is a graphical interface, customized dashboards with application foundation and Business Objects SDK, drag and drop, familiar business terms, powerful reports in less time, and that it is user friendly.
4.How many modes are there in Business Objects and Designer
In Business Objects and Designer, there are two modes, enterprise mode and workgroup mode.
5.What are Enterprise and Workgroup modes?
Through designer, universes can be saved in enterprise or workgroup mode. If you’re using enterprise mode, it’s for an environment with a repository. On the other hand, workgroup mode means you’re working without a repository. How you save your universe will dictate whether or not other designers can get to them. If you do not specify where the universe is to be saved, it will automatically be saved in the mode that you’re already working in.
6.How do you save a Business Objects document which can be accessed by all users in workgroup mode?
In order to make a universe that is available to another designer who is without a repository, click “Save For All Users” box under the Save as universe box.
7.What is online and offline mode?
Online default mode in Designer is for when you’re working in an environment with a repository, whereas Offline mode is for when you are not tied to a repository. To make a universe available in offline mode, you need to make sure that it has been opened once or more in online mode, and that it’s been saved by clicking “Save For All Users,” as demonstrated above. Once you’ve done that, you can access offline mode when you the repository is not available to you because the network is not accessible or because you are working from a different location. You must have connected in online mode at some point. You will be able to get into databases where connection and security information is kept on your device.
8.What is a universe?
A universe is made up of classes and objects named in business terms. Essentially, it maps the table and columns in the database to classes and objects from the query panel. It’s logical data mapping in business terms. Universes also allow end users in the Business Objects User module to build queries to generate and perform analysis. Universes isolate end users from the difficulties of database structure and SQL syntax. If you’re looking for a refresher on SQL syntax, check out our Introduction to SQL Training.
9.Can a Universe connect to multiple databases?
10.How do you define universe parameters?
Universe parameters will include its name, a description, and a connection to an RDBMS. The parameters should be input in the Universe Parameters box, which will also allow you to set up external strategies, graphic options, and print settings.
11.What is a database connection?
A database connection allows access to an RDBMS based on parameters. These parameters have system information like user ID, data account, and the path to the database. There are three kinds of connections: secured, shared, and personal.
12. What are the differences between Personal, Shared, and Secured connections?
Personal connections are created by a single user and cannot be used by others. It can only be used on the computer that created it. Whereas, shared connections can be used by others through a shared server. Unfortunately, rights and securities on objects cannot be set in a shared connection, nor can a universe be exported to a repository. Finally, secured connections overcomes the limitations that a shared connection has. Rights can be set on objects and documents, but universes can only be exported to the central repository through a secured connection. This is the safest form of connection to protect data.
13.How do you design a universe?
When designing a universe, there are two big steps you must go through. The first step involves designing the database structure of your universe, including tables and columns of the database, as well as the joins that will link them. Any loops that arise in the joins should be resolved using contexts or aliases. This step ends by testing the integrity of the structure as a whole. The second step is where you improve and fine tune the components of your universe. Once you are done, you want to test the integrity of the universe again and if all checks out, you can distribute your universes to other users by exporting them to the repository or using the file system.
15.What are the components of the Designer interface?
The Designer interface is where you build universes from the Universe pane, the Table Browser, and the Structure pane. From the Universe pane, you see the components of the universe from the BusinessObjects perspective, including classes, objects, and conditions. Then from the Table Browser, you can create objects and classes of the universe using the tables and columns in database. Lastly, the Structure pane allows you to see the make-up of the universe including columns, joins, and tables.
16.What are classes?
A class is a logical grouping of objects within a universe. In a universe about to human resources, one class might be employees. Then, you can subdivide a class into subclasses. In the same example, a subclass of employees might be personal information. The designer is able to create a structure of classes and subclasses that is best suited for that particular business.
17.What are objects?
The most basic part of a universe, is an object. An object maps directly to data or to a derivation of data in the database. Objects in a human resources environment might include employee names, addresses of employees, salaries, bonuses.
The above 17 questions and answers are just the tip of the iceberg! They have been some of the most commonly cited interview questions in Business Objects, so they should provide a great starting point to your review. In addition to reviewing those questions, you might want to brush up on Computer Science and Learn SQL in 6 Days so that you’re sharp for the interview.