Business Objects Interview Preparation Guide
Download PDF

Business Objects guideline for job interview preparation. Explore list of Business Objects frequently asked questions(FAQs) asked in number of Business Objects interviews. Post your comments as your suggestions, questions and answers on any Business Objects Interview Question or answer. Ask Business Objects Question, your question will be answered by our fellow friends.

42 Business Objects Questions and Answers:

1 :: Let me know the things we can do in WEBi and cannot do it in FULL CLIENT and vice verse for BO6.5?

1) we can create edit Universe in the full client but not in WebI

2)WebI has comparatively less functions to use than in Full client

3) In Full Client we can write macrosaddins but i am not sure whether we can do the same in WebI or not.

The main difference between fullclient and webi is in webi only universe can be used as source,whereas in fullclient we can freehand sql,stored procedures and xml dataproviders as source.

2 :: Explain Are Data mart and DWH normalized or denormalized? Do both of them exist in
the same tier?

Yes both can exist on the same tier because Datamart is a subset of data warehouse and it supports a particular region, business unit or business function.



The data in the Datamart and DWH is Denormalized and optimized for OLAP systems

3 :: Explain How to schedule the report in B.O?

We can schedule the reports through broadcast agent.

4 :: Explain When to use local filter and when to use global Filter?

Think this should be in the Reporter Forum but, a local filter would apply to just a single block (table, cross tab or chart) within your report.

a global filter would apply to all blocks in your report, so if you had many tables the filter would apply to all of them

5 :: Explain What is the difference between slice and dice and cross tab report?

Cross tab report is like at the intersection of 2 dimensions measure is displayed.like if we have two dimensions year and product and a measure revenu,revenue is displayed at the intersection of year and product.

6 :: Explain How can we do load testing for Webi Reports? (Example if I have have to test one webi report for Concurrent users refreshing report at one time)?

You can do Load testing for Webi Reports using Load runner tool.

1) Install loadrunner in your system. ( to use loadrunner you need admin rights).

2) Generate loadrunner scripts.

3) Use controller(which is present in loadrunner) to get the results.

Using loadrunner tool you will get these results:

a) Maximum Running Vusers: 50 ( Given by the testing person, you can increase virtual users if you want)

b) hits per second.

c)Average response time for every transaction like login,click on the particular link,logout etc.,

d) Errors per second.

e) Connections per second.

7 :: What is the difference between BoXIR2 and BOXIR3?

1.XIR3 can use Excel document as a data provider which was not possible in XIR2.

2.We can open XIR2 universes using XIR3 Designer but XIR3 universe cannot be opened using earlier versions of designer.

8 :: What is the difference between User And versatile user?

SUPERVISOR offers various types of users of Business Objects products. The user profile determines by default what products a user can use. User profiles can be customized to reflect the needs of the users.

User (all products but DESIGNER and SUPERVISOR)
Versatile (configurable)

USERs use the Business Objects end-user products to query, report, and analyze data. They may also use the optional REPORTER and EXPLORER modules for multidimensional analysis. End users can produce documents containing data from one or more data sources.

A versatile user is a customized user who may be given access by a supervisor to any combination of Business Objects products.

9 :: What are all difference between business objects 6.5 and XI R2?

I have found some differences b/w BO and XI and only the last is specific to XIR2

Difference between BO and XI



BO uses classic BO Architecture and XI uses crystal classic Architecture



BO uses 57 tables for BO repo and 8 tables for auditor where as XI uses 8 tables for CMS and 6 tables for auditor



BO has different security domains where as XI doesn?t has no different security domains



BO, all objects are stored in repository where as in XI Objects are physically stored in Input FRS and instances in output FRS



In BO after installing we have configure, create BO mainkey where as in XI it is install and start working



In BO classic key is an xml file and it has to be placed in relevant location where as in XI a key code is there



In BO if you want to save a report to repository you have to publish that report where as in XI if you click save as and select Enterprise



IN BO, BCA and supervision are entirely separate but in XI there are merged into CMC



IN XI there is no separate auditor is there but there is an auditor database where we can create tables based on that



BO has it?s own reporting toos where as XI uses crystal reports as it?s reporting tool



BO is user centric ? means rights are assigned to user where as XI is object centric ? means rights are assigned on objects level not user level



BO ? all reports are stored in categories, in XI infoview there is folder and categories but all main storage is in folders



In XI R1 there was no concept of full client but that concept is introduced in XI R2

10 :: What is difference between Webi and Infoview?

In infoview you can create a webi documents i.e wid documents, you can open, schedule, save it as an excel or pdf or business objects document(.rep).

Webi is a part of Infoview

Webi rich client is basicaly use as a windows application (Online as well as Offline)..Here No need for web connection.But

InfoView is a web portal of BusinessObjects where we can create reports in connected mode.It need web connection to run the reports.