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 derived table in data warehousing?

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

Answered by: Praveen Guntuka on: Oct 31st, 2014

Derived table is like view in SQL. We can insert multiple columns from multiple tables into it. We can write complex code to fetch the user required data. These tables cannot holds data, whenever we u...

Answered by: bharath on: Oct 21st, 2014

Actually derived tables are database view only...... like aggregate tables(materialized views) but aggregate tables are created in ETL developers in database leval but Derived tables are created by bo developers in universe level..... created use of custom sql.........

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

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

Answered by: bharath on: Oct 21st, 2014

If there is missing cardinality or traps assume that there is a n to n relation its leads to "cartision product" so we have to resolve to check check integrity.........

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.

How to configure b.C.A in b.O?

Asked By: dreamfrn | Asked On: Jun 19th, 2007

Answered by: bharath on: Oct 21st, 2014

BCA means "broad casting agent" actually this is used for version migrations and backup from of biar files ....but it is in bo3.0 to bo6.0 it upgraded to "import wizard" in boxi 3.1 now latest versi...

Answered by: morad talouh on: Jul 11th, 2012

Actually bca is used to schedule and deliver reports not for securities. securities are handled by supervisor tool in older versions of bobj. supervisor is the old cmc. please rectify the answer.

Computationa and multivalue errors

Asked By: intouch | Asked On: May 10th, 2008

How to resolve computationa and multivalue errors?

Answered by: RAJU on: Sep 21st, 2014

When we try to insert object result into one cell resolution for the error is use agree function is do not insert object
into cell make a column in table

List of values description

Asked By: anonymous521 | Asked On: Feb 12th, 2010

How to add a description to the list of values?

Answered by: anil on: Sep 3rd, 2014

A list of the distinct values from the column or columns to which the object refers

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

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

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.

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.