Top Answers to Business Objects Interview Questions
Criteria | Result |
Querying and Data analysis | Ad-hoc querying & complex data analysis |
Total cost of ownership | Low due to integrated, scalable, highly available, BI enterprise platform |
Ease of use | Extremely user friendly, with quick up time |
Business object detect the solutions for business professionals which could be beneficial to gain data from the corporate database directly from the desktop.
- There are many advantages of business objects
- Easy to use
- Dragging and dropping
- Graphical interface
- Business terms that are familiar
- Powerful reports for a lesser amount of time.
Read this top-rated blog to find out why BusinessObjects is such a sought-after Business Intelligence tool.
Learn Business Object in 18 hrs from experts
There are various products related with business objects
- Broadcast Agent
- Info View
- Supervisor
- Auditor
- Designer
- Set Analyzer
- User module
Designer is a set which is linked with Business object IS utilized by designer for developing and maintaining universe .Here universe is the semantic layer which can resolves the problem of end user issues that are technical related to the database.
There are two kinds of modes related with designer
- Workgroup mode
- Enterprise mode
There are two different methods:
- Drill down
- Slice and Dice
- There are various kinds of users
- Supervisor Designer
- Designer
- Graphical Interface
- Supervisor
- General Supervisor
- Versatile User
- End User
BO allows us to review data from various sources. We can use data from RDBMS such as MS SQL server, Oracle, etc.
There are various kinds of data providers are:
- OLAP servers
- Queries over universe
- Personal data files
- SAP
- VBA procedures
- Stored procedures
- Free hand-SQL
It is a kind of study mode related to BO and helps in breaching data as well as in presenting data from all the available angles and the levels of details for analyzing the factors which caused the good and bad result.
It can be made only by one user and can’t be used by the others. The details for same are kept in a PDAC.LSI file.
It is opposite of personal connection as it can be used by others also through a server which is common one. In this details of connections are kept in SDAC>LSI file which is there in installation folder.
It is a kind of connection which overcomes the disadvantages related with the former connection. We can use universe in central repository by secured connection.
It defines the universe for providing the drill down which is customized and occur between objects from same or different classes taking care of the user requirements.
We can create custom hierarchies by clicking on tools then choosing hierarchies from BO designer.
Context can be explained as the specific path of join between a specific group of joins or the tables for the purpose of a specific query.
We can create custom hierarchies by clicking on tools then choosing hierarchies from BO designer.
It is a situation which arises at the time when the value in the fact table get wrong when it is measured from two various fact tables.
It can be solved by two methods:
- By using SQL parameter in universe which generates SQL statement for each measures and result into a correct output.
- The second one is involving two joints in different contexts.
They are created in the universe. It is used for complex calculations which can’t be sorted out in the report level. The other useful feature of derived table is that by using dblink we can use the table from other schema.
It is a universe of classes and objects which is developed by the universe designer. Once the objects which is there in the universe does not matches our requirement, then the user can create his own objects which is known as User objects.
The @functions are:
- @where
- @ Prompt
- @ script
- @Variable
- @Select
The @prompt function tells the end user to write any specific values.
The @script function recovers the result of the Visual Basics for applications macro’s.
The @select function re-used the existing statements.
Three Domains are there in Business Objects
- Document
- Security
- Universe
Take charge of your career by going through our professionally designed Sap Business Object Training Videos.
It is a kind of connection which overcomes the disadvantages related with the former connection. We can use universe in central repository by secured connection.
Using @Derived_table function, we can use one derived table from another. The syntax is:
@derived_table(derived table name)
It is used to reset, rename and omit the blocks. It works with the master or detailed reports.
- Dice: It shows the data and removes the data.
- Slice: It reset, rename and delete the blocks.
Big block of data can be break into small sections by using master or detail report. Replication in values can be avoided by using this.
Collection of objects in a universe is known as class. Subclasses are derived from the class.
- There are three ways:
- The Master approach.
- The Kernal approach.
- The Component approach.
It is a process by which we can extract the needed details from the database.
The available Drill modes are;
- Drill down.
- Drill up
- Drill through.
- Drill by
We use aggregate_awarness function to define one object for measures in fact tables when we have a same fact tables in different grains, the syntax is as,
@aggregate_aware(highest_level.lower level)
A one to many join links to a table which answer with another one to many join links is known as fan trap.
The question or the data source is known as the data provider.
Context is developed when the dimension objects are their in one or both fact tables.
Only the clients inside the group can be accessed in the standard mode.
There are five different schemas supported by Business Objects designer
- Snowflake schema.
- Star schema
- Normalized production schema
- Multistar schema.
- Data warehouse with aggregates.
It is to make the users know up-to-date information. Channel is a website with ‘push’ technology.
User objects are not common between the end users. It is kept in a specific user object definition file. Hence if any end-user tries to refresh or edit the query contains another user’s user object, it will be routinely cleaned and removed.
Give your career a big boost by going through our Business Objects Certification now!
The tasks are:
- Creating the universe.
- Designing the universe.
- Distributing the universe.
- Maintaining the universe
The main components are:
- The structure pane.
- The table browser
- The universe pane.
We use report bursting for maintaining the version documents according to the user profiles.
It is a solution that is particular in supporting the decisions related with reports, queries, and analysis.
Decision Support Systems.
Strategies is used for extracting automatically structural data from database or from a flat file.
Universe is a group of objects and classes. These objects and classes will be projected for an application or a set of users.
Secured mode blocked the contact of specific users over specific commands.
Drill by is used to move to other hierarchy and examine the other data, which belongs to another hierarchy.
It is a file which has the data values linked with an object.
Looking to master SAP Business Objects? Go through the Business Objects Training.
business intelligence specialist interview questions, sql interview questions for business intelligence analyst, business intelligence developer interview questions, common business intelligence questions, business intelligence manager interview questions, entry level business intelligence interview questions, best business intelligence interview questions, business intelligence analyst interview questions,
accenture business objects interview questions, bo universe interview questions, sap bo webi interview questions, sap bo admin interview questions, sap bo idt interview questions, sap bo 4.1 admin interview questions, business objects interview questions for 4 years experience, sap bo scenario based questions