- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
Business Objects Interview Questions & Answers - Learning Mode

Business Objects Interview Questions & Answers - Learning Mode

Business Objects is a French enterprise software company, specializing in business intelligence (BI). BusinessObjects XI, with components that provide performance management, planning, reporting, query and analysis, and enterprise information management.

Try Business Objects Interview Questions & Answers - Exam Mode

1 2 3 4 Next

Sort By : Latest First | Oldest First | By Rating

Business Objects Interview Questions & Answers - Learning Mode
Try Business Objects Interview Questions & Answers - Exam Mode
Question: What would you consider as your biggest achievement and why?

Answer: THOUGH my biggest achievement is still to be achieved ,and that would be if I am able to give all the happiness to my family along with a reputed professional position. Source:
Question: What are all difference between business objects 6.5 and XI R2

Answer: 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 w Source:
Question: What is a fantrap in Business Objects?

Answer: Actually FAN TRAP is a problem that occurs in Universe Level. Loop occurs while we design the universe.

Two Types of Loop Problem:


Definition: Two One-to-many table link eachother is in turn linked another one-to-many table.


Definition: Two Many-to-one table converges on one single lookup table.

Loop can be detected while INTEGRITY CHECK is done. An option is the Source:
Question: What is the difference between BoXIR2 and BOXIR3?

Answer: 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. Source:
Question: Give the notes and functionalities of cascading prompts,@script in business objects

Answer: Syntax

@Prompt ('message', ['type'], [lov], [MONO|MULTI], [FREE|CONSTRAINED])

message is the text of a message within single quotes.
type can be one of the following: 'A' for alphanumeric, 'N' for number, or 'D' for date.
lov can be either a list of values enclosed in brackets (each value must be within single quotes and separated by commas) or the name of a class and object separated by a backslash and within single quotes. Source:
Question: I have three predefined prompts.In a report it will come randomly.How they will come in a specified format?

Answer: The Prompts will appear in the alphabetical order.

To make them appear in the order of our requirement, need to prefix a numerical with the prompt
Question: What is a Data Cube?What is its use ?

Answer: Data cube will present in BO tool.

Data cube is used for storing the data values which we are using in the documents.

We can clear the data cube by using purge command.

Data provider is used to retrived the datas from data cube to documents.
Question: How we drill up week to Month?

Answer: In data Warehouse when u change + symbol to - , u would c all the aggregation level in that + this is called rolling down.

So if u again click over that - it would again compressed back to +. This is call drill up.

your Aggregation levels woudl b like


So by changing the symbol from - to + at month aggregation level u can drill up.
Question: What is a bo repository

Answer: Repository means set of database tables, Business object store security information e.g user, group, access permission, user type etc. , universe information e.g. objects, classes, table name, column name, relation ship etc.and document information Source:
Question: When we use aggergate awarness function in designer?

Answer: 1. In order to solve fan trap in busines objects we either create alias table or aggregate awareness function

2. Through aggregate navigation we can also select the compatable as well as incompatable objects

Ex:-year, quarter, month, week, day

year:-quarter, month, week, day are compatable objects

quarter:-year?class is incompatable and month, week, day are compatible.

3. We specify the objects in descending order

Question: How to filter repeatative values in the report to get distinct values.

Example: In any database we can use distinct command But My Report source is flatfile.Therfore,I cann't manipulate source system.

Is there any command or function to filter repeating records/values in the report.

Answer: Using the eliminate duplicates option is one way.

In a clightly different scenario, duplicates could come up due to the design structure of the report. e.g.

In some specific cases, one may want to display a value in one field (say in a folded report) but multiple values come up (which could give you a COMPUTATION ERROR). To avoid such situation, one can define a variable which would e the max of the original field required. That ways the same value is fetched and also only one val Source:
Question: Are Data mart and DWH normalised or denormalised ? Do both of them exist in
the same tier ?

Answer: 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 Source:
Question: What is the diferrence between slice and dice & drill through

Answer: Slice and dice means change the postion of the data like move the data from rows to columns

drill mode means allow u to analyze the data in different angles and different levels of details..

in drill mode different types of analysis's are there like drill up, drill down, drill accross, drill through.

drill through means option to select any step or level directly from the current level..

these are the main difference between slice and dice and drill through
Question: clearly explain the difference between union and group

The difference between union and group is as follows:

take two tables t1 and t2.

in t1 we have columnss like a,b,c,d. and t2 has a,d,e,f.

so union means t1 union t2 i.e getting result from both tables i.e a,b,c,d,e.,f

where as group performs on a indiviual column in a particular table.
Question: What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

Answer: Cartesian product is getting incorrect results.

for instance if we have a cham trap or a fan trap n we din't solve them after checking the integrity also we get duplicate results of the same record ie nothing but cartesian product.


we have customer,orders,loans classes

orders for one product if the product_price is 150$ it will appear twice in the report due to traps bcoz of the cartesian product thats why to solve the cham trap we create context and in orde Source:
Question: How do we test the reports in the business objects? How to creates the tabs in the reports?

Answer: In the central mangement consol one can test the report. jsut go to the link http://ipadress:port no/businessobjects/enterprise11/admin/en/admin.cwr .every thing can chk from the bo. Source:
Question: How can we do load testing for Webi Reports? (Example if I have have to test one webi reoprt for Concurrent users refreshing report at one time)

Answer: 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 fo Source:
Question: What are the user requirements in a universe?

Answer: Database connections, key column, joins and check for loopif you need mesures, metrics, Source:
Question: What is the difference between condition & filter.

Answer: Conditions: these retrievals the data based on the condition (universe level)Filter: it brings the data and filter; performance will be slow (report level) Source:
Question: What is meant by Object Stores?

Answer: Object store is nothing but the container of object which is created after rpt file run once. Source:

1 2 3 4 Next

India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.34375 Seconds