GeekInterview.com
Series: Subject: Topic:

BO Designer Interview Questions

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

Isolated joins in universe

Asked By: mohdmushtaqahmed | Asked On: Nov 15th, 2007

What are isolated joins? Whether there will be any problem if we have isolated joins in our universe?

Answered by: Kishore on: Jul 5th, 2012

Hi ......
Isolated joins is ex: i have 15 table A is 7 table B is 7 Table taken last is missing in the table that is the Isolated Joins

Answered by: ravi_kumar_garre on: Nov 20th, 2007

Isolated joins form when a new table added to universe and the new table has to be adjust with some of existing context.  This type of Joins called Isolated Joins.

Regards,
Ravi Kumar Garre

In what situation we have to use alias& and in what situation we to use contexts?

Asked By: SAMARTH | Asked On: Dec 14th, 2006

Answered by: jagadeesh.dwbo on: Jun 7th, 2012

Alias: When we have 2 dimension tables with 1 fact table in the schema at that time it is best way to resolve the loop using Alias.We can create alias on lookup table which has both ends 1-1 relations...

Answered by: vengi on: May 23rd, 2012

More than 3 dimension tables and one fact table is there in that scenario on that situation we use alias technics.

What is block? Types of blocks?What is locking systm in universe?What is shortcut join where it is neccessary?

Asked By: naveen | Asked On: Aug 19th, 2006

Answered by: vengi on: Jun 1st, 2012

shortcut join: direct joins b/w the two tables by eliminating the intermediate tables.......the main purpose of this join is improve the performance of the query

Answered by: BalamuruganS on: Jun 1st, 2011

Locking of universes:When you are to import a universe , you will be going to File->Import.A dialog box opens where you can browse the universe you want to open.If you double click on the universe ...

What is the difference between bo and web intelligence

Asked By: sri | Asked On: Jan 2nd, 2007

Answered by: Mohd Sarim on: Jul 13th, 2011

Info view is nothing but another name of web intelligence. we also call it BO thin client.

DeskI is thick client as we need software installed on the system to access BO reports etc whereas in case of WebI the BO installed on the server and we need to access it through our browser

Answered by: Kumaresh Goplsamy on: Jul 25th, 2007

Infoview is a portal to access the Business Objects in Web intelligence.  Business Objects                                                                     web intelligence1.Multiple data providers...

What is the difference in creating filters in designer and business objects?

Asked By: business | Asked On: May 3rd, 2006

Answered by: thilak on: Sep 27th, 2006

In addition to this,when we use the filter in Universe ,it filters the data when the  query run against the database. This will increase the performance.when we use the filter condition...

Answered by: thilak on: Sep 27th, 2006

In addition to this,when we use the filter in Universe ,it filters the data when the  query run against the database. This will increase the performance.when we use the filter condition...

Hai..... I hvae linked 2 data provider..And generate the report ..In that report how can I find the which data is comming from which data provider...?

Asked By: anildevireddy | Asked On: Oct 15th, 2006

Answered by: nanis38 on: Jun 16th, 2011

We can also find out by using DataProvider() function at report level

Answered by: sumesh on: Mar 6th, 2007

Go to View -->structure...
Here you can find the data providers name in Map tab..

What is pragma?

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

Answered by: Ravi on: Dec 8th, 2005

A PRAGMA statement appears in a PL/SQL block. It is not an executable statement, but it provides instructions to the compiler.

Answered by: kiranvileti on: Nov 19th, 2005

# pragma pack preprocessor dirictive specifies the byte boundary for packing members of c structures.syntax: #pragma pack(n)

What are universe requirements?

Asked By: raghu | Asked On: Jul 21st, 2006

Answered by: gaurav07 on: Oct 7th, 2010

Universe requirements 1) Database connections which you manually select2) Classes and objects which maps the data from tables and columns of database3) Create or automatically extract joins4) Set card...

Answered by: Nayef Almiseher on: Dec 4th, 2006

Hi ,

First thing you have to create connection with the DataBase which you want to work on it .

Then you can take tables and put them in the Universe and starting analyzing them .

Regards ,

Eng. Nayef Almiseher

Saudi Fransi Bank

Saudi Arabia

Context

Asked By: Interview Candidate | Asked On: Jul 30th, 2005

A method by which designer can decide which path to choose when more than one path is possible from one table to another in the universe.

Answered by: gaurav07 on: Oct 7th, 2010

Context :   defined as a group of joins shares common business purpose                    ...

Answered by: rupesh.sivaguna on: May 28th, 2009

Context:

Contexts are a collection of joins which provide a valid query path for Web

Intelligence to generate SQL.

Regards,
Siva

What is the difference between aggregate awareness and index awareness? Where are they used and how can be used?

Asked By: Latha03 | Asked On: Jan 23rd, 2007

Answered by: gaurav07 on: Oct 7th, 2010

Aggregate awareness: First understand the usage of aggregate awareness. information is store in database is in summary form.instead of recording the date and time each time a certain product is s...

Derived tables

Asked By: Honed | Asked On: Feb 26th, 2010

How a derived table is useful than a view in database? What are the additional features derived table provides?

Answered by: Divyaprashanth07 on: Sep 4th, 2010

Derived table are created at the universe level. 1. They are usually created to fetch results from tables using a complex logic condition. 2. To get the Max/ Min date for the data set. Usually u...

Answered by: smghurde2 on: May 21st, 2010

Derived tables are tables that you define in the universe schema. You create objects on them as you do with any other table. A derived table is defined by an SQL query at the universe level that can b...

What is row level security

Asked By: chaitanya | Asked On: Jun 27th, 2007

Answered by: sri_emd on: Jul 29th, 2010

The measure of specifying which rows a user can retrieve based on a column of data or combination of columns is called row level security

Answered by: Kumaresh Goplsamy on: Jul 25th, 2007

HI,   It is a security implemented by the supervisor for accessing particular data from the database . This can be done by 1.login to BO supervisor .2.Go to universe tab3.select the&nbs...

What is the drill up , drill down, drill by , drill trough ?

Asked By: Interview Candidate | Asked On: Aug 7th, 2005

Drill up : one level up in the hirearchydrill down: one level down in the hirearchydrill by : direct selection of level in the hirearchydrill trough : to drill data from one hirearchy to another hirearchy

Answered by: pavanbo on: Jul 20th, 2010

Drill up means up in the hierarchy.
Month:-Quarter:-Year

Drill down means down in the hierarchy
Year:-Quarter:-Month

Drill through means you can drill through to the database directly from drill mode and get the required data

Drill by means you can select one hierarchy to another hierarchy

Answered by: sithusithu on: Jan 27th, 2006

Drill up : UP-one level

Drill down: DOWN-one level

Drill by : selection of level Hierarchy

Drill trough : Hirearchy to another Hirearchy

Cheers,

Sithu

Universe

Asked By: Interview Candidate | Asked On: Jul 30th, 2005

A mapping of the data structure found in databases: tables, columns, joins, etc. A universe, which is made up of classes, objects, and conditions, can represent any specific application, system, or group of users.

Answered by: amaresh1981 on: Sep 9th, 2009

An universe is an symanteic layer between the user and the Designer which contains connection of a database

Answered by: ravi_kumar_garre on: Nov 20th, 2007

Universe is a Semantice layer that maps the data structure found in databases (tables, columns, views..etc) to Business Terms.

Cheers,
Ravi Kumar Garre
ravi_kumar_garre@yahoo.co.in

Universe creation issues

Asked By: mrvenkatd | Asked On: May 26th, 2009

What are the common issues faced during creation of universe?

Answered by: cvkr4u on: Jul 20th, 2009

Mainly we face the issues like loops and traps.

Boxir2 tools

Asked By: sahiti27 | Asked On: Feb 20th, 2008

Can any one tell me the tools and complete architecture of boxir2? And also each tool is used for what purpose?

Answered by: sagarikaka on: Jun 24th, 2009

BOXIR2 Tools:1. Business Objects Designer: Enables u to create universes.2. Desktop Intelligence: Allows you to analyze data, perform ad-hoc queries to fetch  new data, and create reports. Often ...

Answered by: Priyank Bhayani on: Jul 22nd, 2008

Universe designer is used to create universe which will be used in desktop intelligence to create reports. BO XI is also having an import wizard tool which will be used for taking backup in biar file ...

How to create groups in business objects designer?

Asked By: Isa Ashour | Asked On: Aug 27th, 2006

Answered by: sharmampooja on: Apr 28th, 2009

Their is no option to create groups in Designer, you have to use CMS to create groups.

Regards

Mohit

Answered by: Nits on: Jan 3rd, 2007

Hi,I had also faced similar problem while using math specific functions in BO, I can suggest you how I did was replicating the same logic using sql in oralce first and then overriding the query in rep...

Alias

Asked By: Interview Candidate | Asked On: Aug 3rd, 2005

A logical pointer to an alternate table name. The purpose of an alias is to resolve lOOPS in the paths of joins.

Answered by: ASHOK1324 on: Apr 19th, 2009

An alias is identical to base table with different name. The data in alias is exactly same as original table/but the different name tricks SQL into accepting that we are using 2 different tables. ...

Answered by: Suresh on: Jun 25th, 2006

Actually, What happens in the back end (i.e) in database end, while alias is performed, whether it points to one table or too many table. How the performance will be in universe level.

Please help me by explaining with this concept correctly, because i faced such question by interviewer.

Shortcut join

Asked By: Interview Candidate | Asked On: Jul 30th, 2005

A join that links two tables by bypassing one or more other tables in the universe.

Answered by: ASHOK1324 on: Apr 19th, 2009

A. short cut joins are used to improve the query performance at universe level i.e. for performance tuning. Suppose if we have 4 tables A,B,C and D A--->B---->C---->D and there is a chance to...

Answered by: ravi_kumar_garre on: Nov 20th, 2007

Shortcut join allows to define an alternative, faster join path between two tables. without the use of a shortcut join, query would have to go through a huge fact table to create simple reference lists.


Cheers,

Ravi Kumar Garre

Hierarchy

Asked By: Interview Candidate | Asked On: Jul 30th, 2005

An ordered series of related dimensions used for multidimensional analysis.

Answered by: ASHOK1324 on: Apr 19th, 2009

Hierarchy is an arrangement of objects for report to report interactions [RRI]. It is used for drill-down and drill-up operations in universe design.

Answered by: sithusithu on: Jan 27th, 2006

a series of dimensions used for analysis based on user requierments

Cheers,

Sithu

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

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.