Common Interview Questions

1) What is Universe.

2) How can we create Universe.

3) What are the parameters that we are using at time of Universe Creation.

4) What is Repository.

5) How can we restrict rows in the report in Business Objects.

6) What is .key file.

7) What are Domains.

8) Can we create a report with Data Providers.

9) What are Locks.

10) What is Broad Cast Agent.

11) What is trouble shooting in Broad Cast Agent.

12) What is Adhoc report.

13) What are Loops in Business Objects. How to Use it.

14) Definition of Universe.

15) Explain grouped cross tab.

16) Who launches the Supervisor.

17) How do you write Factorial function in PL/SQL.

18) What is Refrense Cursor.

19) What is Procedure and Function.

20) Who launches the Supervisor.

How do you access data sources?

BUSINESSOBJECTS lets you access your data through a graphical user interface.

You need no technical knowledge of the underlying data structures to get the information you want. What you do need, however, is knowledge of your business.

To access a data source with BUSINESSOBJECTS, you build a data provider.

The types of data providers supported in BUSINESSOBJECTS depends on whether you install BUSINESSOBJECTS from the installation CD or install BUSINESSOBJECTS via an Internet browser.

What data sources are available?

BUSINESSOBJECTS let you access data from a wide range of sources. You can access data from

• Relational databases (RDBMS), such as ORACLE, Microsoft SQL Server, Informix and IBM DB2.

• Multidimensional (OLAP) databases, such as Microsoft OLAP Services, Hyperion Essbase, and ORACLE Express.

• Text files and spreadsheets

• Packaged applications such as SAP

• Virtually any data source using Microsoft Visual Basic for Applications (VBA) procedures.

Keeping a document’s data up-to-date

Databases are regularly updated with new data. A document generated at a given point in time reflects the data as it existed at that time, but it may be inaccurate now.

BUSINESSOBJECTS lets you update the data in a document while keeping the same presentation and formatting, either manually, or automatically at specified times.

When you update a document, BUSINESS OBJECTS reconnects to the database, and retrieves the updated data.

This is called refreshing a document.

What about security?

The repository is set up and administered by the BUSINESSOBJECTS supervisor. All of the rights you have as a user are granted by your BUSINESSOBJECTS supervisor using BUSINESSOBJECTS SUPERVISOR.

The supervisor defines:

• The parts of the BUSINESSOBJECTS interface you can access. Your supervisor can restrict the availability of BUSINESSOBJECTS functionality, such as access to certain menu commands.

• Your database connections

• The universes you can access for creating and editing queries

The rights accorded to each user define the user’s profile. This profile-based security system allows a single document to be distributed to many users -- with end users having access only to the information that they are authorized to see.

Where does the data come from?

BUSINESS OBJECTS makes it easy to access data from your corporate database because it has a business-intelligent, semantic layer that isolates you from the technical issues of the database. This semantic layer is called a universe. A universe maps to data in the database, using everyday terms that describe your business environment. This means you can select exactly the data that interests you using your own business terminology.

In your company or organization, universes are created by a universe designer, using BUSINESS OBJECTS DESIGNER. The designer then makes universes available to you and other users, so that you can access the data you want from the database through an intuitive, user-friendly interface A Business Objects Universe.

Using this interface, you build a BUSINESS OBJECTS query using an editor called the Query Panel, by adding and organizing objects from a universe. Objects are elements that map to a set of data from a relational database in terms that pertain to your business situation. When you run the query, BUSINESS OBJECTS connects to the database and retrieves the data mapped to the objects you selected.

A query is a type of data provider. The data provider contains the data you have chosen to retrieve from the data source. Using this data set, you can build interactive reports.

BUSINESS OBJECTS lets you access data from a wide range of sources: from relational and multidimensional databases, from packaged applications, from personal data files, and, using Microsoft Visual Basic for Applications procedures, from virtually any source.

BUSINESS OBJECTS

What is BusinessObjects?

BUSINESS OBJECTS is an integrated query, reporting and analysis solution for business professionals that allows you to access the data in your corporate databases directly from your desktop and present and analyze this information in a BUSINESS OBJECTS document.

BUSINESS OBJECTS makes it easy to access this data, because you work with it in business terms that are familiar to you, not technical database terms like SQL. You don’t need any knowledge of the database structure or technology.

Once you’ve used BUSINESS OBJECTS to access the data you need, you can present the information in reports as simple as tables or as sophisticated as dynamic documents with drillable charts.

You can then save those documents for your own personal use, send them to other users, or publish them to the corporate repository for potentially even broader circulation.