Business Objects Interview Questions

This contains the data retrieved from database. when we run a query against the database in the report the resulted data would be stored in the microcube.

Like WEBI, we can choose our needing fields and become a new query, then we can use our creating microcube for the report.

Yes you can overwrite the Query in Webi,but with restriction. please note that free hand sql in not supported in Webi, all you can do is play around with the Where clause, or change the select conditi...

Yes, My Man you can write or overwrite SQL in Webi. Go to Edit Query and On your left top you will see the SQL Icon. Click on it window will open along with gray out. If you want to read that OK or i...

In BO XI 3.1 universe designer... File> Parameters> link tab... add a universe..

Business Objects Designer is a software tool that allows you to create universes for Web Intelligence and Desktop Intelligence users.Designer provides a connection wizard which allows you to connect t...

Tools>Integrity Check...

Local filters define at report level whereas global filters are define at universe level.

Local filter apply on particular report (one table), global filter apply all the table in one tab.

we have three kind of filters;
1.universe level filter
2.query level filter
3.report level filter

Query filters
Report filters

I need full example of #multivalue error............how the errors r coming..............n how to solve that errors

Multivalue error will occur when more than one row comes for one cell. to avoid this issue you have to use Min(), or Max() as per your requirement.

Syntax error will occur when available improper formula used in the report.  so you have to correct it first.

No We cannot apply both simultaneously. If we want apply Drill and then Hyperlink only Hyperlink will be considered.

Yes, we can apply drill and hyperlink in column. First apply drill and then select the column to which you want to apply hyperlink. Right click on the column and select option hyperlink.

Section provide the analysis in sub group vise, suppose we have thee column country, region, revenue, if we apply section on country the table structure change (table structure not change in break) an...

Section divides the Report in various parts based on the simillar entities.

If we want report for US and France Seperately, we can apply sections to view different reports for both.

We can link different data providers in a single report by merged dimension.

Use the merged dimensions to link the data providers. It will give you a dialog for the selection of the dimensions in both data providers. select the dimensions which are alike and merge.

We have to go for 80-20 rule. It means understanding the user requirement first, database, connection secured, table map, join, cardinality, loop, trap, if need then for performance issues we have to create (aggregate, aware,index,derived table,short cut join) test universe

Universe is used for Importing tables, Creating classes, Creating objects, Creating joins, Loops, Fan trap, Chasm trap, Creation of hierarchies, Dimensions, Filters, Breaks, Sections.

Without cardinality we have trouble to solve problem of chamtrap, fantrap.

Cardinality used to Relate the Schema in tables. So if there is no cardinality, forms the errors like duplicate data comes into existence.

Alerters used for to remind/to alert about something that for your specific point of view.

Alert Basically provide your attention toward something you want on it. like you are analysis the Revenue associated with City and Department and you dont want to check all the report total till end. ...

Derived tables can define the suquery of a Table. derived table has a query in the form of Logical tables in designer to accomplish task by writting query in query panel.

Derived Table is a Virtual and Dynamic table in schema. It is not a Physical table but Act like a Physical table. why we make that? We can create/store most usable Dimension in it to reuse frequently ...

Custom hierarchy is used in Scope of Analysis, we can decide the hierarchy as per requirement. For e.g. if there is a hierarchy Year Report hierarchy is created at Universe Level.

Report Based Hierarchy is a by default Hierarchy which Designer created in Designer by making a Classes and Objects. Custom Hierarchy is your choice just like you have Dimension year, Quarter, Month,...

It is common Universe problem when you start to built schema to the scratch. Loops & Traps. Loop: it is the close join path circle where you cant out with resolving the loop. In this case you would h...

Chasm trap The Chasm trap occurs when two many to one joins converge on a single table. For example a customer can place many orders/and or place many loans. Fan trap The Fan trap occurs when a one to...

There are 3 types of Hierarchies in Universe Design. 1- Time Hierarchy: it represents like Year, Quarter, Month, Week, Day. 2- Geographical Hierarchy: It represents like, country, State, City, Town ...

Hierarchy, is set at universe level and there are two kinds: Natural and Custom Hierarchy. Hierarchy is the order of the objects you want to drill through in the reports, say, for example, Time Hiera...

For acheiving this result. You should have at least one common dimension in both Data Provider and data type should be the same. Then you need to click on Merge Dimension icon from menu bar and Dilou...

Two data source which has two table has to be merged with a common dimension,then build the report

Qaaws : As you know Query As a Web Service. It is generate the URL for using in Dashboard to access report data as a Data Source.
Live Office : Bessically is a technique how to connect Dashboard with your different data source through Excel. It can be Webi, Crystal, Excel etc... file.

Qaaws is nothing but a query as web service,when you are generating report in Qaaws at that time one URL can generated that URL can send to the end user.Live office is nothing one of the connector in ...

when you have a restriction and you dont want to bound the variable or Object then you need to make Predefine filter in Universe. For example. you have city Object and there is couple of people using ...

There are 4 filters

Pre defined filters
custom filters
prompts filters
quick filters

Pre defined filters are created at the Universe level.In the Universe window,select the object,right click ,select condition then enter the condition name and filter conditions