Business Objects

2008-02-08T09:52:00.000-08:00

>>previous>>

WebIntelligence Explorer

WebIntelligence explorer allows users to drill in “drillable” WebIntelligence documents to analyze data on different levels of details.

WebIntelligence document containing a drillable chart

This chart illustrates an organization’s sales revenue by state and by year. If required, you can drill down for more detailed information, such as results per city and/or per quarter.

What does WebIntelligence share with BusinessObjects?

The common technology offers a high level of interoperability between the two products, such as:

• The sharing of user rights

Users have access to the same corporate storage areas whether they’re using

WEBINTELLIGENCE or BUSINESSOBJECTS.

• The sharing of documents

With WEBINTELLIGENCE, users can view and refresh documents that have been created then sent to them using BUSINESSOBJECTS. They can also send the documents they create in WEBINTELLIGENCE to BUSINESSOBJECTS users, or publish those documents to the corporate repository for their own use.

• The sharing of the INFOVIEW module, which provides the document catalogs that form an overview of the information that has already been extracted from the database. It serves as the common portal for viewing and downloading documents.

>>>Next>>>

2008-02-08T09:42:00.000-08:00

>>Previous>>

WebIntelligence uses the same universes created for the full-Client users. These universes are the sole data providers for WebIntelligence documents.

WEBINTELLIGENCE uses the same universes created for full-client users. These universes are the sole data providers for WEBINTELLIGENCE documents.

All users need to do to create and edit WEBINTELLIGENCE documents is to log into a web server and download a Java applet or ActiveX control from the corporate intranet, extranet, or the web. They can then build queries to create documents that display accurate, up-to-date data from their corporate databases.

When users have finished editing the queries, they send them to the server, where they are processed, formatted and sent back as HTML documents.

You can then save those documents for your own personal use, send them to other users, publish them to the corporate repository, or schedule them for automatic refresh and distribution through BROADCAST AGENT.

>>>Next>>>

2008-02-08T09:26:00.000-08:00

>>Previous>>

WebIntelligence is the leading business intelligence solution designed to meet your critical query, reporting and analysis need using today’s Internet technology. With Web-Intelligence, users can access the data in their corporate databases or data warehouses from within the office, their homes, or around the world, using the corporate intranet, extranet, or the World Wide Web.

Webintelligence comes in three modules:

WebIntelligence InfoView

The base module of the business objects solutions is an e-Business Intelligence portal called INFOVIEW, which provides users with a single entry point to all the documents they need. This module is user-customizable, so that their copies of the INFOVIEW fit their needs a s closely as possible.

Infoview also includes the document viewer control that application developers can embed in other application.

InfoView lets user view, refresh, manage and distribute documents, but do not create or modify them. To do that they need the WEBI and/or Business Objects reporter modules or BO installed through a web browser.

At the heart of InfoView is the document list

The document catalog includes up to three lists containing files they can access:

• The Corporate Documents page contains files that have been saved or uploaded to a document domain in the corporate repository and made accessible to workgroups within the corporation or organization.

• The Personal Documents page contains documents users have saved for their own personal use.

• The Inbox Documents page contains documents other users have sent each user.

• When users click on a third-party file, such as a Microsoft Word document or an Adobe Acrobat PDF file, if the associated application is installed on the client machine, the application is launched with the file open in it. If the application is not installed, users can choose to download the file to their machine.

Icons representing the type of file

>>>Next>>>

2008-02-08T08:50:00.000-08:00

>>Previous>>

BUSINESSOBJECTS 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 BUSINESSOBJECTS document.

BUSINESSOBJECTS 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 BUSINESSOBJECTS 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.

You can add images and embedded objects and format your documents to high presentation standards for viewing on screen or for printing.

On-report analysis allows you to switch your business perspective by dragging and dropping data, insert on-report calculations or drill into a report for detailed information:

You can quickly and easily share the documents you have created with other
users in your company, either by sending them directly to selected individuals or groups, or by publishing them as corporate documents. When you distribute documents in these different ways, you use the BUSINESSOBJECTS repository.

The repository stores the documents you send so that other users can retrieve and view them. It also stores information about the documents it stores, such as name of sender, date and time, and also which users in the company have the right to retrieve and view a document.

>>>Next>>>

Common Interview Questions

2008-01-27T11:24:00.000-08:00

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.

2008-01-27T11:19:00.000-08:00

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.

2008-01-27T11:18:00.000-08:00

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.

2008-01-27T11:12:00.000-08:00

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.

2008-01-27T11:08:00.000-08:00

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.

2008-01-27T10:36:00.000-08:00

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

2008-01-27T10:33:00.000-08:00

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.

Freqently Asked Qns

2007-12-30T14:04:00.001-08:00

21. What are the differences between a formula, variable and user objects?

22. Did you face any problems while creating reports? Name? Solutions?

23. How do you schedule the reports?

24. How were the reports scheduled and how to resolve unexecuted documents?

25. What is a micro cube? How many can a document have?

26. Have you worked with multiple data sources? If yes. How do you link them?

27. What are templates? Explain what you have created?

28. I have some multi data providers (excel, text, universe). I want only retrieve the data from excel only. How to write the query in query panel?

29. What is slice and dice? What is the use of slice and dice?

30. What is core dimension?

31. How do see the query performance in report?

32. I want to display the last refresh report date and time in the below of the report, how will you do that?

33. While running the query how much time it will taken, I want to see the time?

34. What is Report Bursting?

35. What is the use of alias and context? Which is the better for solving the loops? Why? Why we use alias and why we use context?

36. How to improve the query performance in to report level and designer level?

37. I have 3 tables A, B, C. I connected A to B and B to C. I want to report ABC, is there any loop problem will occur or not?

38. I have 4 tables A, B, C, D. I connected A to B, B to C, C to D and D to A. I want to report ABC, is there any loop problem will occur or not? What is the Problem?

39. How to interactive with Clients?

40. Can u tell me, what is the major problem you faced in your experience? How did you resolve the problem?

41. I have one problem? My Client to told resolve the problem with in 2 hours, but its taken by full day (8 hours). How will u convince the client?

42. How Many Classes and Objects you have in your Universe?

Freqently Asked Qns

2007-12-30T14:02:00.000-08:00

1. What is an Universe?

2. How many Universes did you create?

3. Tell me how many classes where there, and objects in each class?

4. What is Object qualification?

5. Tell me about a complicated object you have created?

6. What was the size of the database? Which server?

7. How many user were there?

8. What problems you have faced while creating an universe? tell me
an incident and how you went about solving it?

9. Were any experts called from BO while you were on the project?

10. What was the Database? Was it a data warehouse?

11. How many Tables was the universe built?

12. What is a loop, how do you resolve them?

13. What do prefer an Alias or a context? Why?

14. What is join? Explain different types of joins?

15. What are linked universes? Have you worked with them,
problems faced and solutions?

16. How many reports have you created? Explain a few?

17. What are alerters, filters, breaks, and master-detail?

18. What's the difference between master-detail and Breaks?

19. What's the difference between filters and conditions?

20. What are pre-defined conditions? Compare with report conditions? Justify?

Business Objects

Categories

WebIntelligence uses the same universes created for the full-Client users. These universes are the sole data providers for WebIntelligence documents.

Common Interview Questions

BUSINESS OBJECTS

Freqently Asked Qns

Freqently Asked Qns