SAP BO Interview Questions And Answers

   SAP BO Interview Questions And Answers

   What is SAP BusinessObjects ?

SAP BusinessObjects BI (also known as BO or BOBJ) is a suite of front-end applications that allow business users to view, sort and analyze business intelligence data. The suite includes the following key applications:

• Crystal Reports — Enables users to design and generate reports
• Xcelsius/Dashboards — Allows users to create interactive dashboards that contain charts and graphs for visualizing data
• Web Intelligence — Provides a self-service environment for creating ad hoc queries and analysis of data both online and offline
• Explorer — Allows users to search through BI data sources using an iTunes-like interface. Users do not have to create queries to search the data and results are shown with a chart that indicates the best information match.

    The suite is the result of SAP’s October 2007 acquisition of the French company Business Objects.
Explain detail objects ?

Detail objects are attached to dimensions; one cannot drill on details nor link on details when linking multiple data providers. While Customer ID would be a dimension, customer name, address, phone and soon should be details.

    What is BOMain.Key ?

BoMain.Key file contains the information about the repository site i.e. it contains the address of the repository security domain.

    What is Business objects Repository? – Types ?

• it is nothing but metadata.
• CMS Repository: Which consist of two database (System & Audit)
• Input file repository: Template of the report
• Output file repository: Instance of the report

Or

The Business Objects repository is a set of relational data structures stored on a database. It enables Business Objects users to share resources in a controlled and secured environment.

     What is domain? How many are there in a basic setup? What are they ?

Domain is nothing but logical grouping of system tables, there are three domains usually in a basic setup, they are Secure, Universe, and Document. Business objects are sometimes called domain objects (where the word domain means the business), and a domain model represents the set of domain objects and the relationships between them.

     When is the Repository created ?

At the time of installation

     How do you restrict access to rows of a database ?

Using row level security in designer we can restrict access to rows of database.

     What is a category ?

It is nothing but grouping of certain entities.

     What is a Universe ?

It is a semantic layer between Database and the designer used to create objects and classes. (It maps to data in Database).

     What is an Object ?

It is an instance of class, its nothing but an entity.

     What is a loop? How can we overcome ?

Loop is nothing but a closed circular flow; it can be overcome by making use of Alias and Context.

     What is a join? Explain different types of joins ?

Join is used to link to tables depending upon the data requested by the user, Usually we have Inner Join, Outer Join, Left Join, Right Join, Full Outer join.

    What are Linked Universes ?

If the data provided is from two different data providers then we can link those two universes, such type of universe is called Linked Universe.

    What are Alerter, Filters, Breaks and Conditions ?

Alters are nothing but they are used to draw attention to a block of data by highlighting. Breaks are nothing but grouping the data without any change in the format. Condition is used to retrieve data which meets certain criteria. Filters are used to get necessary data.

     What is the difference between master-detail and Breaks ?

In break common fields are deleted (here in this case the table format is not changed) whereas in master-detail , we declare certain entity as a master to get the detailed information or report in this case the table format is changed.

     How can we improve performance?

By making use of Aggregate tables.

     How can you check the integrity ?

By making use of Check integrity button.

     What are Universe parameters ?

1.    Defination
2.    Summary
3.    Strategies
4.    Controls
5.    SQL
6.    Links
7.    Parameters

    How do you restrict access to the rows of a database ?

1.    In the User pane, click the user or group.
2.    In the Resource pane, click the Universe tab.
3.    Right-click the universe.
4.    From the pop-up menu, click Properties.
5.    In the Universe Properties dialog box, click the Rows tab.
6.    Set the options as necessary.
7.    Click Ok

    What are Connection types available in BO ?

1.    Secured
2.    Shared
3.    Pesonal

    what is isolated joins in check integrity ?

• Isolated join is the join which is not included in any of your contexts, so you are getting that error.
• Solution: First of all find what are all the joins you left without including in any of your contexts and join them to any of the context which you think appropriate. Then go for Integrity check.

    What is fantrap and chasmtrap ?
    

      Chasm Trap :

Chasm trap means many-to-one and one-to-many join relation converge on to a single lookup table, because of this we get incorrect results i.e., Cartesian product, We will resolved by using sometimes alias, sometimes context, sometimes shortcut join and check multiple context for each measures option.

      Fan Trap :

Fantrap means one-to-many and one-to-many join relation of the tables it is detected by visual analysis, because of this we get incorrect results i.e., cartision product, We will resolved by using some times alias, some times shortcut join and check mutiple sql statements for each measures option.