SAP BO Developer Interview Questions and Answers
- Explain detail objects? –
Ans: 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? –
Ans: 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?
Ans: 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
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? –
Ans: 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? –
Ans: A repository is created at the time of installation.
- Can we have multiple domains? –
Ans : Yes. (Security domain cannot be multiple).
- How do you restrict access to rows of a database? –
Ans :It can be done by using row-level security in designer module.
- What is a category? –
Ans :It is nothing but grouping of certain entities.
- What is a Universe? –
Ans : 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? –
Ans :It is an instance of class, its nothing but an entity.
- What do you mean by Object qualification?
Ans :- Object qualification represents what kind of object is that, usually we have three types of object qualifiers they are measure, dimension, detailed.
- What is the size of data base? –
Ans: In general it will be anything between 4-8 Terabytes.
- What is a loop? How can we overcome? –
Ans: 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? –
Ans :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? –
Ans : 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?
Ans: – 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? –
Ans : 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.
- What is metrics? –
Ans : Metrics are a system of parameters or ways of quantitative and periodic assessment of a process that is to be measured; these are used to track trends, productivity.
- What is a Set? –
Ans : Its nothing but grouping of users.
- What is the use of AFD? Where it can be stored? –
Ans :Used to create dashboards. It can be stored in repository, corporate or personal.
- What is the source for metrics? –
Ans : measure objects.
- Why do we need metrics and sets? –
Ans: Metrics are used for analysis and Sets are used for grouping.
- Is there any bug in 4.x? –
Ans: In earlier version of 4.0 they had, but 4.1/4.2 is the best version.
- What are the general issues in migration process? –
Ans: Alignment, performance.
- What is the use of BO SDK? –
Ans: Bo SDK main use is to suppress “no data to fetch” using Macros.
- How can we improve performance? –
Ans: By making use of Aggregate tables.
- Analysis in BO? –
Ans: Slice-Dice and Drill analysis.
- How can you check the integrity? –
Ans: By making use of Check integrity button.
- What are Universe parameters? –
Ans: Name of the universe, description and RDBMS connection, size and rights.
- Types of Universes? –
Ans: Simple and Complex.
- Can we have multiple domains? If yes. Purpose of having them?
Ans: Yes, Having multiple document domains can help with organization. If you stick with the ‘canned’ document domain, all documents (BCA, user to user, corporate, universe lov’s) all wind up sharing the same domain/default table space. You can create separate domains with separate table spaces for the different types of documents and reduce the risk of space related Repro problems and corruption. Also, you can reduce the risk that problems corrupt your entire Repro.
- How do you restrict access to the rows of a database?
A) 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.
- How do you Create a user?
A) 1) In the User pane, click the group in which you want to create a new user. 2) Click on the toolbar. 3) Type a user name, and press the Enter key.
- What is the use of BCA? –
Ans : BCA is used to refresh and schedule and export and save as.html,.rtf,.xls ,.pdf.
- Explain about BOmain key in detail?
Ans :BO Main key will store the address for repository of the security domain.General path for BOMainKey C:\Program Files\Business Objects\BusinessObjectsEnterprise 6\LocData
- What is the degenerated Objects?
Ans :Objects created using SQL queries or stored procedures called Degenerated Objects.
- What is casual dimension?
Ans : Casual dimension is should not change the fundamental grain of a fact table. Ex: sex- Male, Female.
- What is the use of Surrogate Key in BO?
Ans :It is used for duplicate values in a data base primary keys cannot be changed when a unique error occurs with the help of this surrogate key a new column values will be created and that will be as primary keys.
- what is meant by scorecards?
Ans: Scorecard is a concept used for measuring a company’s activities in terms of its vision and strategies, to give managers a comprehensive view of the performance of the business.
- What is security domain in Business Objects?
Ans: Security domain checks the users & their privileges.
Security Domain : It contains all user name & Password.Like it ll hold all the User credential information.
- Types of universes in business objects?
Ans: There are two types of Universes1. Ad_hoc Universe .2. Non Ad_hoc Universe .
- What is the test methodology for testing BO Universes?
Ans : Integrity Check is the option through which one can test the universe in BO.
- What are different types of saving options in web intelligence?
Ans : we can save as excel, RTF and .rep
- What is the difference between Thin client & thick client?
Thin client we can also called as Web Intelligese where as thick client also called as desktop intelligese.The main diff b/w thin & thick client,in webI,wecan create reports using only universe but using DeskI we can create reports by using data providers are XML data provider,VB application,universe,storedprocedure,databae,sap r/3 etc
- What services the broadcast agent offers on the server side?
Ans: We can monitor the Scheduled Reports are controlled in the server side. We can resume or cancel the reports running in the Broad cast Agent.
- What are Connection types available in BO?
a. Securedb. Sharedc. Personal
- What is holap?
Ans:Hybrid online analytical processing (HOLAP) is a combination of relational OLAP (ROLAP) and multidimensional OLAP (usually referred to simply as OLAP). HOLAP was developed to combine the greater data capacity of ROLAP with the superior processing capability of OLAP. HOLAP can use varying combinations of ROLAP and OLAP technology. Typically it stores data in a both a relational database (RDB) and a multidimensional database (MDDB) and uses whichever one is best suited to the type of processing desired. The databases are used to store data in the most functional way. For data-heavy processing, the data is more efficiently stored in a RDB, while for speculative processing, the data is more effectively stored in an MDDB. HOLAP users can choose to store the results of queries to the MDDB to save the effort of looking for the same data over and over which saves time. Although this technique – called “materializing cells” – improves performance, it takes a toll on storage. The user has to strike a balance between performance and storage demand to get the most out of HOLAP. Nevertheless, because it offers the best features of both OLAP and ROLAP, HOLAP is increasingly preferred.
- What is molap?
Ans: MOLAP (multidimensional online analytical processing) is online analytical processing (OLAP) that indexes directly into a multidimensional database. In general, an OLAP application treats data multidimensionally; the user is able to view different aspects or facets of data aggregates such as sales by time, geography, and product model. If the data is stored in a relational data base, it can be viewed multidimensionally, but only by successively accessing and processing a table for each dimension or aspect of a data aggregate. MOLAP processes data that is already stored in a multidimensonal array in which all possible combinations of data are reflected, each in a cell that can be accessed directly. For this reason, MOLAP is, for most uses, faster and more user-responsive than relational online analytical processing (ROLAP), the main alternative to MOLAP. There is also hybrid OLAP (HOLAP), which combines some features from both ROLAP and MOLAP.
- What is Rolap?
Ans: Relational online analytical processing (ROLAP) is a form of online analytical processing (OLAP) that performs dynamic multidimensional analysis of data stored in a relational database rather than in a multidimensional database (which is usually considered the OLAP standard). Data processing may take place within the database system, a mid-tier server, or the client. In a two-tiered architecture, the user submits a Structure Query Language (SQL) query to the database and receives back the requested data. In a three-tiered architecture, the user submits a request for multidimensional analysis and the ROLAP engine converts the request to SQL for submission to the database. Then the operation is performed in reverse: the engine converts the resulting data from SQL to a multidimensional format before it is returned to the client for viewing. As is typical of relational databases, some queries are created and stored in advance. If the desired information is available, then that query will be used, which saves time. Otherwise, the query is created on the fly from the user request. Microsoft Access’s PivotTable is an example of a three-tiered architecture. Since ROLAP uses a relational database, it requires more processing time and/or disk space to perform some of the tasks that multidimensional databases are designed for. However, ROLAP supports larger user groups and greater amounts of data and is often used when these capacities are crucial, such as in a large and complex department of an enterprise.
- How do you know if a user is disabled?
A) A sad face means the user has disabled him/herself by failing the password check X number of times. A user disabled intentionally via the Supervisor module will have a red circle X over him/her.
- How do you enable a User?
Ans :Right click on the disabled user and select enable.
- What is Object qualification?
Ans: For the purposes of multidimensional analysis, objects are qualified as one of three types: dimension, detail, or measure.
- Where is the address of Security Domain stored?
Ans : It is stored in BOMain.key file
- Can a General Supervisor create two Domains of same type within a single data account?
- How to see the report to all users ?
Change the connection type to Public
- Can I use the 2 databases in Universe?