GeekInterview.com
Series: Subject: Topic:

Business Objects Interview Questions

Showing Questions 1 - 20 of 394 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

What is a microcube?

Asked By: jiggley67 | Asked On: Oct 15th, 2007

Answered by: Sasikumar on: Aug 5th, 2014

When you create data query in SAP business Objects the data retrieved and stored in a Micro cube.This Micro Cube is stored along with the report and the report size will vary based on the saved micro ...

Answered by: Rajkamal Choudhary on: Jul 18th, 2014

Microcube is the kind of middle ware between report and database, data comes from database and first store in microcube and the populate in reports so all the reporting calculation are based on microcube data.

Is SAP business objects offered as independent bi solutions or is it tied with SAP

Asked By: numbsyd | Asked On: Jul 15th, 2014

Hello, is SAP bo being offered as independent bi solution or is it completely integrated into SAP as a replacement for bw. I was told by a bo developer its not being offered as an independent solution for companies not using SAP software. thanks for your help. regards, sid

Answered by: Rajkamal Choudhary on: Jul 18th, 2014

Hi, SAP Business Objects is a independent product although it was independent company earlier. we can buy it without SAP R/3, ECC or SAP BW.

What are the different types of filters available in business objects?

Asked By: kalu | Asked On: Oct 31st, 2007

Answered by: Riaz Sultana on: Apr 30th, 2014

There are 2 types of filters in BO.

1. Global: which is at universe level filter

2. Local : This is further divided into 2 types:

(a) Query filter
(b)Report filter


Query filter is further divided into 2 types:

(a) Static filter
(b) Dynamic filter

Answered by: S.Arun rao on: Apr 21st, 2014

There are 3 types of filters in BO they are:

1)Global level filter : Filter is applied at universe level.
2)Query level filter : Filter is applied at the time of creating a query in webI reports.
3)Report level filter : Filters applied on report..filter can be block level or report level

How does the hierarchy and scope of analysis helps in reports. How does these both gets related.

Asked By: Raj | Asked On: Sep 18th, 2006

Answered by: chandra on: Mar 28th, 2014

Hierarchy: It is order series of dimensions in a class. We can do multidimensional analysis if Hierarchy exists in Universe.

Scope of Analysis: we can set limit to the level for Multidimensional Analysis.

Answered by: lionskashif on: Aug 30th, 2012

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

Can we overwrite the SQL query after creating the report

Asked By: selvakumarn | Asked On: Oct 12th, 2006

Answered by: chandra on: Mar 28th, 2014

Yes we can override SQL Query if option "Allow other users edit the Query" is enable in the Edit Query Properties.

Answered by: Sumesh on: Apr 25th, 2013

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

What happens to business objects report if the cardinality is not specified??

Asked By: jaya_gundala | Asked On: Feb 16th, 2007

Answered by: Chandra on: Mar 28th, 2014

If Cardinality is not specified then we will face error "Cardinality is not specified" in Integrity check in Universe.

Answered by: vishwanath_bhambure on: Oct 18th, 2013

Cardinality must be there to propose the context for resolving the loops in universe structure.

Can you create alerts in web intelligence?

Asked By: Saibabu Garimella | Asked On: Sep 6th, 2006

Answered by: purvanshu on: Feb 11th, 2014

Yes all version of BO you can create alerters.

Answered by: sundeep reddy on: Feb 10th, 2014

Yes we can create filters in webi

What is a derived table in data warehousing?

Asked By: Monali | Asked On: Jun 29th, 2006

Answered by: sudheerv2k on: Nov 25th, 2013

Advantages of derived table: It can be created using an SQL statement with complex expressions, joins and prompts which are not possible to create in BO Universe using normal approach. It acts just l...

Answered by: vishwanath_bhambure on: Oct 18th, 2013

Derived tables are somewhat like Views in the database. we can write select statement to create the such table which contains more than one table and join conditions, filter conditions in their query....

Please explain about alerts in bo's, under what situation we need to use alerts

Asked By: Prasanth nandamuri | Asked On: Jul 10th, 2006

Answered by: vishwanath_bhambure on: Oct 18th, 2013

alerter are used at the reporting level. this are used to attract the user attention to the value. Example : Suppose i will create one alerter which will highlight all the student roll nos in Red c...

Answered by: vyankatesh valakate on: Oct 19th, 2012

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

How to use two universes with different database connections in the same application?

Asked By: sai .khere | Asked On: Sep 26th, 2013

Answered by: vishwanath_bhambure on: Oct 18th, 2013

Using Data synchronization.

We have to merge the dimension from both the data providers in the report to generate the report using the two different data providers.

Option 2 :
Make DBLINK between Database A & B and access both the database tables by pointing application to one of the database.

Answered by: lionskashif on: Oct 7th, 2013

Well, If you are using BO4 then you would need to make to Relational Conn.(RC) point out to required Databases and than you will able to make it Datafoundation (DF) based on two source databases.
Hope it helps.

How can we add two universe?

Asked By: ranjith | Asked On: Mar 26th, 2007

Answered by: MAnil on: Mar 16th, 2013

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

Answered by: poornima on: Apr 18th, 2007

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

How to debug the universe in designer module

Asked By: Venkat | Asked On: Apr 25th, 2007

Answered by: MAnil on: Mar 15th, 2013

Tools>Integrity Check...

When to use local filter and when to use GLobal filter?

Asked By: bhargav | Asked On: Nov 18th, 2005

Answered by: Cosmos on: Mar 9th, 2013

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

Answered by: shashank on: Dec 13th, 2012

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

Multivalue and syntax error

Asked By: kusam_m | Asked On: Dec 27th, 2007

What is #multivalue and #syntax error in business objects

Answered by: avinash kumar on: Feb 10th, 2013

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

Answered by: ag_SRIDHAR_SUBRAMANI on: Sep 24th, 2008

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.

Drill and hyperlink

Asked By: SheelaSamuel | Asked On: Sep 15th, 2010

Can we have both drill and hyperlink working on same column? Explain

Answered by: shyam on: Feb 8th, 2013

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

Answered by: Lakshmi on: Jan 21st, 2013

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.

What is a section in a business objects report?

Asked By: jiggley67 | Asked On: Oct 15th, 2007

Answered by: shashank on: Dec 13th, 2012

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

Answered by: vyankatesh Valakate on: Oct 19th, 2012

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.

How do you link different data providers in a single report?

Asked By: vasanth96 | Asked On: Jul 11th, 2007

Answered by: shashank chakraborty on: Dec 13th, 2012

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

Answered by: hari on: Nov 7th, 2012

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.

What are the user requirements in a universe?

Asked By: bhargav | Asked On: Nov 18th, 2005

Answered by: shashank on: Dec 13th, 2012

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

Answered by: Vyankatesh Valakate on: Oct 19th, 2012

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

What is difference between custom hierarchy and report based heirarchy?

Asked By: reddeppa | Asked On: Jan 13th, 2006

Answered by: Ravinder Singh on: Sep 3rd, 2012

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

Answered by: lionskashif on: Aug 28th, 2012

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,...

What is the chasm and fan traps in business objects

Asked By: prashanth.rainfall | Asked On: Sep 29th, 2011

Answered by: lionskashif on: Aug 30th, 2012

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

Answered by: jee on: Sep 30th, 2011

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

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.