CoolInterview.com - 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
COOLINTERVIEW.COM DATA WAREHOUSING INTERVIEW QUESTIONS BUSINESS OBJECTS INTERVIEW QUESTIONS 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: CoolInterview.com
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:

1) FANTRAP PROBLEM solved by ALIAS METHOD:

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

2) CHASM TRAP PROBLEM solved by CONTEXT METHOD:

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



Answer: Syntax

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

where
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: CoolInterview.com
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: CoolInterview.com
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

Year>Month>Week>Day>Hour>Minutes>Seconds.

So by changing the symbol from - to + at month aggregation level u can drill up.
Source: CoolInterview.com
Question: clearly explain the difference between union and group



Answer:
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.
Source: CoolInterview.com
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.

ex:-

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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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

Source: CoolInterview.com
Question: Product date sales
p1 20/Jan/1999 100
p1 20/Feb/1999 200
p1 20/apl/1999 100
p1 20/DEC/1999 50
p1 20/Jan/2000 100
p1 20/mar/2000 500

now i want query like
product ,sum of actual year ,sum of business year
p1 450 750

here actual year means 1 Jan 1999 to 31 st Jan 1999
business year means 1 st APR 1999 to 31 st mar 200



Answer: Guess you can try this

(select product,sales S_A_Y from info where date >= 1 st Jan 1999 & date =<
31 st Jan 1999 groupby product) sal1 ,
(select product,sales S_B_Y from info where date >= 1 st Apr 1999 & date =<
31 st Mar 2000 groupby product) sal2
where sal1.product=sal2.product ;
Source: CoolInterview.com
Question: Can you please clarify the difference between compatible and incompatible objects? when we will use these two?



Answer: When you are defining Aggregate tables in Universe design, you need to create hirarchies for aggregated objects, for that you need to make the relative objects incompatible (the objects which are of lower level of aggregation -- not of hirarchy).

If you have Year,Quarter,Month,Day as a hirarchy, while aggregation, you need to define as follows -

Year - Quarter,Month,Day Compatibles

Quarter - Month, Day Compatibles, Year Non-compatible

Month - Day Compatible, Year,Quar Source: CoolInterview.com
Question: Can someone please give some information on REPORT BURSTING and how to do it in BCA as i have to split the report and send diff reports to diff people



Answer: If some part of the data in your report is sensative, you can't risk sending the whole report to everybody, even to those who need to see the least sensative part of report !

Solution is Report Bursting.

You can send reports to BCA for scheduled processing & distribution to users based on THEIR profiles (profile = user rights) & not based on your profile !

BO 5 & WebI 2.5 procedure to do this :

Open the document, click "Send to BroadCast Agent" on Doc Exchange to Source: CoolInterview.com
Question: What is drill filter and it's usage ? How many types of filters are there ?



Answer: Three types of drill is in BO.1.drill up,2.drill down,3.drill thro'.

drill up means second->minutes->hour->->day

drill down means region->country->state->district

drill thro'--wht ever u want that element
Source: CoolInterview.com
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: CoolInterview.com
Question: Currently I am sending the report to users in excel format,if there is no data also the report will be sent,Is there any option in BO to stop report from being sent if there is no data in the report?



Answer: The time interval will be fixed for sending the report If you are generating or not a default report will be sent regularly, to stop sending you have to condact your admin Source: CoolInterview.com

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.079102 Seconds