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
BO Designer Interview Questions & Answers - Learning Mode
COOLINTERVIEW.COM DATA WAREHOUSING INTERVIEW QUESTIONS BO DESIGNER INTERVIEW QUESTIONS QUESTIONS & ANSWERS - LEARNING MODE

BO Designer Interview Questions & Answers - Learning Mode

A Business Objects Universe is the semantic layer that resides between an organization's database and the end user but more importantly, it is a business representation of your data warehouse or transactional database. SAP Business Objects Designer: Universe Designer is a graphical design tool used to create the rich ?semantic layer? (metadata) that makes SAP Business Objects products intuitive for non-technical users. It's a graphical abstraction of the dimensional models that exist in your data warehouse.

Try BO Designer Interview Questions & Answers - Exam Mode

1 2 3 4 Next

Sort By : Latest First | Oldest First | By Rating

BO Designer Interview Questions & Answers - Learning Mode
Try BO Designer Interview Questions & Answers - Exam Mode
Question: what is index awareness in universe?

Answer: Index awareness is the ability to take advantage of the indexes on key columns to speed data retrieval. Source: CoolInterview.com
Question: What is mean by aggregate aware?
How we are using this function?


Answer: Aggregate awareness is a term that describes the ability of a universe to make use of aggregate tables in a database. These are tables that contain precalculated data. You can use a function called @Aggregate_Aware in the Select statement for an object that directs a query to be run against aggregate tables rather than a table containing non aggregated data.

Pros:
Speed up the execution of query and Improve the performance of Sql transaction.

If you are using the aggregate tabl Source: CoolInterview.com
Question: Shortcut join



Answer: Short cut join joins the two tables which r already in a path.SCJ skips the intermmediate tables and joins the table which are already in the common path,

using SCJ increases thge performance of the query bcoz the no of tables in the query decreases that means the retreival of the data is more faster rather than before.

for instance if we have customer,orders,order_line classes and cust id object is there in three classes and customer is joined to order_line through orders n we wa Source: CoolInterview.com
Question: Theta join



Answer: Theta join?A theta join is created when the data in two fields from two tables is related via some comparison operator other than equals (=). For example, a not-equal join relates data using the not equal operator (<>). For example, suppose you want to compare the unit price data in Northwind's Order Details table with the unit price data in the Products table. Specifically, you want to see those orders where the unit price of the order differs from the unit price of the product. --- C Source: CoolInterview.com
Question: How do you design a universe?



Answer: The design method consists of two major phases.

During the first phase, you create the underlying database structure of your universe. This structure includes the tables and columns of a database and the joins by which they are linked. You may need to resolve loops which occur in the joins using aliases or contexts. You can conclude this phase by testing the integrity of the overall structure.

During the second phase, you can proceed to enhance the components of your universe. You Source: CoolInterview.com
Question: Enterprise mode



Answer: Enterprise mode means that you are working in an environment with a repository. Workgroup mode means that you are working without a repository. The mode in which you save your universe determines whether other designers are able to access them.

Source: CoolInterview.com
Question: Explain the SQL Queries activated to data base from Data provider in BO ?



Answer: BO automatically generates the SQL query when objects are selected into query panel. When you run the query, the query is processed to database based on your connectivity.

for ex: If you run query using, Local Machine Full Client (BO reporter), the query directly connects to database through midilleware

Full Client <---> Database

If you run query using Webi, the webi browser will connects to Web Server and Webserver will proces request to Database.

WEBI <---& Source: CoolInterview.com
Question: Shared connection



Answer: The secured connections are used to access universe or document. It can be used by several users.

Source: CoolInterview.com
Question: Which command using Query Analyzer will give you the version of SQL server and operating system



Answer: Select @@version is the command that will give the said details Source: CoolInterview.com
Question: Personal connection



Answer: Personal connections are used to access resources such as universe or document

Source: CoolInterview.com
Question: How to create Universe using Flat file in BO6.0



Answer: Business Objects deals with databases, for every universe you need to specify a database connection. flat files dont have the database format so you'll need to convert them into some database. to do that, you will need to write a procedure which will read data from flat files & relate it according to surrogate keys, then using that procedure populate the database & then use that database for the source of the universe.

using flat files ONLY , you can not create universe. because there Source: CoolInterview.com
Question: Could any one expain me how to create cascading prompts?



Answer: if you have source system > source location field.

double click source system > edit properties menu will display, click properties tab and click edit you will get query pane there you pull down source location object in conditon pane and click inlist and click type new prompt type there "XXXXX" and save that.

now you click display button first source system lov will display and you select any one, based on that selection the source location lov will display.

this is c Source: CoolInterview.com
Question: What is the local filter and global filter in bo's?



Answer: Local Filter >>Specific to a block (Table/cross tab/ chart etc..)

Global Filter >> Specific to a TAB in a report

If a report has multiple Tabs, each can have its own Local and Global filters.
Source: CoolInterview.com
Question: What is slicing and dicing in business objects?



Answer: Slice & Dice is facility in BO. we can enables change the positions of data in Report..here in Bo we slice & dice panel by using this we can create cross tables and masterdetails tables. Source: CoolInterview.com
Question: What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?



Answer: Functional Differences :

1.BusinessObjects client needs to be installed on every PC from where you want to build / access reports. WebI needs just a browser & URL(of the server from where it will access BO).

2.BOMAIN.Key file needs to be copied on every individual PC that uses BO client. WebI doesn't need it.

3.You need to stick to those PCs which have BO client installed, WebI can let you access even when you are roaming anywhere in the world(provided the access conditi Source: CoolInterview.com
Question: Drill



Answer: There can be 3 types of Drill Analysis- Drill Down,Drill Up and Drill Through.

Within the same universe one can Drill Up/Down like Country-State-City;of course with facts that relate to the same grain.

A Drill through is possible when we can link different Data Marts like Profitability as defined by details of Asset,Liability,Income and Expense
Source: CoolInterview.com
Question: Condition



Answer: Lets you create a condition. The conditions that you define appear within the Universe window. From the Query Panel, a user can drag the conditions from the Classes and Objects box to the Conditions box.

Source: CoolInterview.com
Question: Outer join



Answer: Outer Join - method of retreiving selected rows from one table that doesn't match rows with the other table.

Source: CoolInterview.com
Question: Broadcost agent



Answer: Broadcast agent is used for scheduling or bursting the reports.

thru this,you can schedule your reports so that end-users can access reports thru internet.

you have broadcast administration console here thru which,you can schedule reports and watch the tasks even.It is an administrator tool of Business Object.
Source: CoolInterview.com
Question: What are the security level used in BO?



Answer: We have securities in business objects

Like

1.Windows authentication

2.RDBMS securities

3.supervisor level securities, ie User name/ password
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.03125 Seconds