SAP BO INTERVIEW QUESTIONS
1. Tell me about what sap business objects?
Ans) Business objects provides a set of tools for building data warehouses very efficiently. Business objects is an integrated query, reporting and analysis solution for business professionals that allow them to access the data in their corporate databases directly from their desktop and present and analyze this information in a business objects document.
2) What is Bo Designer?
Ans) Designer is the Business objects product that is intended to develop the universes. These universe is the semantic layer of the database structure that isolates from technical issues of the database structure.
How many modes are there in BO & Designer?
Ans)There are two modes are there in BO and Designer are :
Enterprise Mode
Workgroup Mode
3. how many products related with sap bo ?
Ans)There are various kinds of products related with business objects and they are
User module
Designer
Supervisor
Auditor
Set Analyzer
Info View
Business Objects – Software Development – Kit
Broadcast Agent
4. what is Designer?
Ans )Designer is a module related with Business Objects IS used by the designers for creating and maintaining universes. Universes can be considered as semantic layer that can isolate the end users from the various issues that are technical and related with the structure of database. Universe designers has the possibility for distributing the universes to the end users after moving these as file through the system of files or can be done by exporting the files to the repository.
5. What are the kinds of modes associated with designer and business objects?
Ans There are especially two different kinds of modes associated with these platforms, they are
Enterprise mode
Workgroup mode
6. various kinds of methods related with multidimensional analysis that is sap bo?.
Ans) two types methods related with multidimensional analysis available inside BO and these methods are
Slice & Dice
Drill down
7. List out the kinds of users associated with business objects.
There are various different kinds of users associated with business object, they are
General supervisor
Supervisor
Graphical Interface
Designer
Supervisor Designer
End User
Versatile User
8. howmany types data sources available in bo
Ans )Business objects help you in accessing the data from variety of sources. You have the possibility of accessing data from RDBMS like oracle, MS SQL server and IBM DB2.
9. what is kind of data providers?
Ans )There are various kinds of data providers available for the business objects and they are
Stored procedures
Queries over universe
Free hand – SQL
VBA procedures
SAP
OLAP servers
Personal data files
10. what is drill mode.
Ans ) analysis mode associated with business objects and helps in breaking down data as well as in viewing data from all the possible angles and the levels of detail for discovering the factor that has caused good – bad result.
11.tellme about personal connection?
Ans ) Personal connection is the created only by a single user and it can’t be made used by others. The details regarding such a connection can be usually stored inside PDAC.LSI file.
12.explain shared Shared connection?
Ans )This is a kind of connection that is usually made used by other user via a server which is shared one. The details regarding the connection can be stored within the SDAC>LSI file which can be found within the installation folder of the business objects.
13. explain secured connection?
And )Secured connection is a kind of connection that can be helpful in overcoming the various limitations associated with the former connections. The rights related with this kind of connection can be set over documents as well as objects. Universes can be brought inside central repository only by making use of secured connection. The parameters regarding these connection care usually saved inside CMS.
14. what is custom hierarchies?
Ans ) The custom hierarchies can be used for defining the universe for facilitating drill down that is customized and can happen between objects from different or same classes considering the user requirements.
15 tell me custom Hierarchies be created?
ans )The custom hierarchies can be created by following the path tools ->hierarchies in BO designer.
16. what is context in the sap bo universe ?
Ans )Context can be defined as the particular path of join between a specific group of joins or the tables for the purpose of a particular query. A particular object that can be found inside the column of a table, belonging to particular context is supposed to be compatible to all the various kinds of objects belonging to the same context. In the case of objects that are from the various kinds of context, different kinds of SQL can be generated, and the results can be merged inside micro cube. This is for making sure that there is no incorrect result associated with a loop or any other kind of issue related with join path.
17. How Contexts be created?
Ans )Context can be created by making use of feature associated with context or by manual procedures. The context are usually created by making use of logical calculation or based on the business requirements. The detect context may not be much useful in this case and so it should be done by making use of manual procedure.
18. what is Chasm Trap in bo?
Ans )Chasm trap is a condition that arises when the values inside the fact table get inflated at the time of measuring the values from two different fact tables by considering the dimensions inside dimension table.
19. How we solve Chasm Trap ?
Ans) Chasm trap should be solved by making use of two different methods.
In the case of SQL parameters in universe, the option generates numerous queries for each and every measure that needs to be chosen. This helps in generating SQL statement for every measure and gives the correct results.
Another approach is to include two joints in different contexts, where the problem will get solved by generating two synchronized queries.
20. howmany utilities of Derived tables?
Ans Using SQL queries from the database level, Derived tables are created in the universe. The columns of the derived table will be the columns selected in the query. Derived table can be used in the complex calculations which are difficult to be achieved in the report levels. Using a dblink, tables can be accessed from a different schema, is another use of derived tables.
21)what is User Objects?
Ans)User objects is a universe of classes and objects which is created by the universe designer. Once the objects consisted in the universe does not matches your necessities, then the user can create his own objects called User objects.
1. Tell me about what sap business objects?
Ans) Business objects provides a set of tools for building data warehouses very efficiently. Business objects is an integrated query, reporting and analysis solution for business professionals that allow them to access the data in their corporate databases directly from their desktop and present and analyze this information in a business objects document.
2) What is Bo Designer?
Ans) Designer is the Business objects product that is intended to develop the universes. These universe is the semantic layer of the database structure that isolates from technical issues of the database structure.
How many modes are there in BO & Designer?
Ans)There are two modes are there in BO and Designer are :
Enterprise Mode
Workgroup Mode
3. how many products related with sap bo ?
Ans)There are various kinds of products related with business objects and they are
User module
Designer
Supervisor
Auditor
Set Analyzer
Info View
Business Objects – Software Development – Kit
Broadcast Agent
4. what is Designer?
Ans )Designer is a module related with Business Objects IS used by the designers for creating and maintaining universes. Universes can be considered as semantic layer that can isolate the end users from the various issues that are technical and related with the structure of database. Universe designers has the possibility for distributing the universes to the end users after moving these as file through the system of files or can be done by exporting the files to the repository.
5. What are the kinds of modes associated with designer and business objects?
Ans There are especially two different kinds of modes associated with these platforms, they are
Enterprise mode
Workgroup mode
6. various kinds of methods related with multidimensional analysis that is sap bo?.
Ans) two types methods related with multidimensional analysis available inside BO and these methods are
Slice & Dice
Drill down
7. List out the kinds of users associated with business objects.
There are various different kinds of users associated with business object, they are
General supervisor
Supervisor
Graphical Interface
Designer
Supervisor Designer
End User
Versatile User
8. howmany types data sources available in bo
Ans )Business objects help you in accessing the data from variety of sources. You have the possibility of accessing data from RDBMS like oracle, MS SQL server and IBM DB2.
9. what is kind of data providers?
Ans )There are various kinds of data providers available for the business objects and they are
Stored procedures
Queries over universe
Free hand – SQL
VBA procedures
SAP
OLAP servers
Personal data files
10. what is drill mode.
Ans ) analysis mode associated with business objects and helps in breaking down data as well as in viewing data from all the possible angles and the levels of detail for discovering the factor that has caused good – bad result.
11.tellme about personal connection?
Ans ) Personal connection is the created only by a single user and it can’t be made used by others. The details regarding such a connection can be usually stored inside PDAC.LSI file.
12.explain shared Shared connection?
Ans )This is a kind of connection that is usually made used by other user via a server which is shared one. The details regarding the connection can be stored within the SDAC>LSI file which can be found within the installation folder of the business objects.
13. explain secured connection?
And )Secured connection is a kind of connection that can be helpful in overcoming the various limitations associated with the former connections. The rights related with this kind of connection can be set over documents as well as objects. Universes can be brought inside central repository only by making use of secured connection. The parameters regarding these connection care usually saved inside CMS.
14. what is custom hierarchies?
Ans ) The custom hierarchies can be used for defining the universe for facilitating drill down that is customized and can happen between objects from different or same classes considering the user requirements.
15 tell me custom Hierarchies be created?
ans )The custom hierarchies can be created by following the path tools ->hierarchies in BO designer.
16. what is context in the sap bo universe ?
Ans )Context can be defined as the particular path of join between a specific group of joins or the tables for the purpose of a particular query. A particular object that can be found inside the column of a table, belonging to particular context is supposed to be compatible to all the various kinds of objects belonging to the same context. In the case of objects that are from the various kinds of context, different kinds of SQL can be generated, and the results can be merged inside micro cube. This is for making sure that there is no incorrect result associated with a loop or any other kind of issue related with join path.
17. How Contexts be created?
Ans )Context can be created by making use of feature associated with context or by manual procedures. The context are usually created by making use of logical calculation or based on the business requirements. The detect context may not be much useful in this case and so it should be done by making use of manual procedure.
18. what is Chasm Trap in bo?
Ans )Chasm trap is a condition that arises when the values inside the fact table get inflated at the time of measuring the values from two different fact tables by considering the dimensions inside dimension table.
19. How we solve Chasm Trap ?
Ans) Chasm trap should be solved by making use of two different methods.
In the case of SQL parameters in universe, the option generates numerous queries for each and every measure that needs to be chosen. This helps in generating SQL statement for every measure and gives the correct results.
Another approach is to include two joints in different contexts, where the problem will get solved by generating two synchronized queries.
20. howmany utilities of Derived tables?
Ans Using SQL queries from the database level, Derived tables are created in the universe. The columns of the derived table will be the columns selected in the query. Derived table can be used in the complex calculations which are difficult to be achieved in the report levels. Using a dblink, tables can be accessed from a different schema, is another use of derived tables.
21)what is User Objects?
Ans)User objects is a universe of classes and objects which is created by the universe designer. Once the objects consisted in the universe does not matches your necessities, then the user can create his own objects called User objects.
