BO Designer Interview Questions
What are isolated joins? Whether there will be any problem if we have isolated joins in our universe?
In what situation we have to use alias& and in what situation we to use contexts?
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...
More than 3 dimension tables and one fact table is there in that scenario on that situation we use alias technics.
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
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
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
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?
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...
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...
We can also find out by using DataProvider() function at report level
Go to View -->structure...
Here you can find the data providers name in Map tab..
A PRAGMA statement appears in a PL/SQL block. It is not an executable statement, but it provides instructions to the compiler.
# pragma pack preprocessor dirictive specifies the byte boundary for packing members of c structures.syntax: #pragma pack(n)
What are universe requirements?
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...
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
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.
Context : defined as a group of joins shares common business purpose ...
Context: Intelligence to generate SQL.
Contexts are a collection of joins which provide a valid query path for Web
Regards,
Siva
How a derived table is useful than a view in database? What are the additional features derived table provides?
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...
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...
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
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 ?
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
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
Drill up : UP-one level
Drill down: DOWN-one level
Drill by : selection of level Hierarchy
Drill trough : Hirearchy to another Hirearchy
Cheers,
Sithu
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.
An universe is an symanteic layer between the user and the Designer which contains connection of a database
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
Can any one tell me the tools and complete architecture of boxir2? And also each tool is used for what purpose?
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 ...
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?
Their is no option to create groups in Designer, you have to use CMS to create groups.
Regards
Mohit
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...
A logical pointer to an alternate table name. The purpose of an alias is to resolve lOOPS in the paths of joins.
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. ...
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.
A join that links two tables by bypassing one or more other tables in the universe.
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...
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
An ordered series of related dimensions used for multidimensional analysis.
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.
a series of dimensions used for analysis based on user requierments
Cheers,
Sithu
User Panel
Categories
Interview Coaching
Ads
Connect
Ads
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.
NH
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
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