50 Most General Business objects Questions

1. What is a universe?
A. Universe is a semantic layer, which maps to data in the database . Collection of classes and objectsB. universe is the symantic layer that isolates the end use from the complex structure of database
2. Analysis in business objects?
A. Slice and Dice and Drill Analysis is available in BO
B. There are two types of analysis . i. slice and dice ii. Drill
3. Who launches the supervisor product in BO for the first time?
A. General Supervisor launches supervisor product
4. How can you check the universe?
A. Using check Integrity, u can check the universe. Go to Designer, Tools -> check Integrity
5. What are universe parameters?
A. You define universe parameters from the Universe Parameters dialog box (File-> Parameters) when you create a universe. The database connection is the onlyparameter that you must manually select or create when you create a newuniverse.B. name of universe,description and rdbms connection
6. Types of universes in business objects?
A. Simple universe and complex universe
7. What is security domain in BO?
A. security domain is bomain.key that allocates each user with a name and password.
8. Where will you find the address of repository in BO?
A. BoMain.key,File that contains the address of the repository’s security domain.bomain.key9. What is broad cast agent?
A. brodcasting agent are used to refresh or publish the document at a regular interval of time broadly speaking BCA is used to schedule the document.
B. Broad Cast agent agent manages scheduling the documents.
9. What services the broadcast agent offers on the server side?
A. It can also help reduce traffic on the network by running reports at off–peak times which, of course, benefits everyone.
10. How can you access your repository with different user profiles?
A. Distribute the Key file according to the option you chose in the Repository Access
11. What are alerters in BO?
A. Alerters are used to draw attention to a block of data either by highlighting or displaying some message near to the cells
12. What are different types of saving options in web intelligence?
A. Save as a personal documentsave this document to InfoView for your personal useSave to my computerSave this document to your computer as:Microsoft Excel format (.xls), PDF Format, BO report(.rep)
13. What is batch processing in BO?
A. It is scheduled process in Broadcasting Agent. Ex: you can refresh a document at a specified date/time. This can be either a one–off process or a process to be repeated at the same time every day, week, month etc.
14. Can we take report on Excel in BO?
A. After creating the report with extension .rep, File – Menu – Save as Excel option can be given.yes, we can take the report in exel sheet
15. I hvae linked 2 data provider..and generate the report ..in that report how can i find the which data is comming from which data provider…?
A. in Report, go to structure mode you can see all the data with its corresponding data provider name as ….Empname (Dataprovidername1)sal(dataprovidername2)
16. suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?
A. Becoz buy a car is a fact & rent a car is a look up,alias is created on look up tables.
17. Can any body will explain about sarrogat key?
A.In a current database, the surrogate key is the primary key,generated by the database management system and not derivedfrom any application data in the database. The onlysignificance of the surrogate key is to act as the primary key.
18. What is the difference between sub-query & co-related sub query?
A.Nesting of queries, one within another, is termed as a Sub-Query.
A sub query is executed once for the parent statement whereas the correlated sub query is executed once for each row of the parent query.

Example Select deptno, ename, sal from emp a where sal = (select max(sal) from emp where deptno = a.deptno) order by deptno
19. WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
Answer The different table templates you can use to displayinformation on reports are:

? vertical tables

? horizontal tables

? crosstabs

? forms

1)Vertical tables display header cells at the top of thetable and the corresponding data in columns.

2)Horizontal tables display header cells at the left of thetable and the corresponding data in rows.

3)Crosstabs display values for dimensions across the topaxis and on the left axis. The body displays the values of ameasure that correspond to the cross section of the dimensions.

4)Forms are useful in your report if you want to displaydetailed information

20. WHAT IS CARTESIAN PRODUCT?
Answer A Cartesian product is defined as all possible combinationsof rows in all tables.
21. WHAT IS CARDINALITY?
Answer Cardinality defines the numeric relationships betweenoccurrences of the entities on either end of therelationship line. eg: 1)0:02)1:03)1:14)0:M5)1:M6)M:M
22. HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Answer When ever we save universe it directly gets saved in local repository. If we want to access these universe from deski or webi then we will have to save these universe to central repritory by EXPORTING it,it will directly be saved in dafault location in central repository.
23. CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Answer no
24. IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
Answer yes
25. TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
Answer I bo the security levels are applied to roe level and coloumn level.Both have been handled by the administrator in supervisor tool (or) in designer tool.these two levels of securities are used to restrict the data at roe level or coloumn level in case of particular user or user group. Row level Security ?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.
26. what is a bo repository
Repository means set of database tables, Business object store security information e.g user, group, access permission, user type etc. , universe information e.g. objects, classes, table name, column name, relation ship etc.and document information.
27. When to use local filter and when to use global Fi...
A filter which applies to a one single block in the report is called local filter but a filter which applies to all blocks in the report ia called as global report filter.
28.How can you suppress the 'No data to fetch' messages in Reports?
There are a number of ways. VBA can be used to set Application.Interactive to Off. But this will also prevent the user from responding to any prompts. You can also adjust your query so that every data provider is a union to a table that returns at least one row, thereby eliminating the possibility of returning no rows. That "special row" should be designed so that it doesn't change (impact) the actual results should they be returned.
29. How can you create a graph with horisontal bars?
put the paper on the table, then get up and move around the corner. Now the chart is horizontal instead of vertical.
30 . When getting 'No data to fetch' msg, how can you make the report to display at least one record?
Again, a union can be used to combine an extra row to a data provider, thereby eliminating the "no data to fetch" message. Or you can have two blocks, one hidden behind the other, where one block is displayed when there is data, and the other block (with a hard-coded text message) displayed only when there is no data in the "real" data provider.
31.How can you import a single-tab report into another multi-table report so the single-tab report will keep its formatting?
Without VBA, use a template. You'll have to recreate the data provider from scratch. With VBA, you can move (copy) the data provider to the multi-tabbed document, then either via VBA or manually use a template to move the formatting. Bottom line is that you use a template to move the formatting, but have to use VBA or manually move the data provider as there is no feature within the product to do this.
32. Can you link the 'universe based' query to one based on RDBMS stored procedure?
I've never tried this, but I don't see why not. Since you can link a universe-based query to a personal data provider, and that works just fine, I don't see why this wouldn't work.
33. How can you display 5 top records only?
Need more information. Do you want the top 5 records based on some other value? Or the "pure" top 5 based on the query? You have a number of choices... use the "rank" feature in BusinessObjects, use "partial results" and limit the rows returned to 5 (using a descending sort to get the right order), or use a Rank() feature of your RDBMS, assuming one is available. But since we're talking about report solutions, that last one probably should not be considered. Issues with the reporter rank function include the fact that all data is returned, resulting in a (potentially) large cube. But it will handle tied results. And by including a break on some other dimension object, you can determine the top 5 per X, or some other value. Issues with the partial results include the fact that ties are not handled properly, and you can only get the "overall" top 5, not the top 5 per some item.
34. What's the Detail object used for?
Officially, any non-defining attribute should be a detail object. So while customer ID would be a dimension, customer name, address, phone, and so on should be details. They are used primarily in an environment where lots of report linking is done. If you don't use the linking technique, then details are less of an issue. Since details are associated with a dimension, once their associated dimension is linked to some other dimension, then the detail object is available (and valid) in a block with combined data. Some objects (date objects come to mine) could be defined in a universe as both dimensions and details. For example, Order Date could be a detail for Order Number. The Order Number only has one Order Date. By setting Order Date to be a detail, you can link on Order Number to some other data provider and continue to use Order Date in the block without the famous "Variables are not compatible" message. Yet you may want to drill on a hierarchy of Order Year, Order Quarter, Order Month, Order Date. In that case, it would have to be a dimension.
35.Can you link the 'universe based' query to one based on RDBMS stored procedure?
I've never tried this, but I don't see why not. Since you can link a universe-based query to a personal data provider, and that works just fine, I don't see why this wouldn't work.
We did this recently. It worked just fine! We had a dataprovider based on the universe and one that used VBA to retrieve data from a stored procedure
36.what is the difference b/w Master detail and Break?
Master detail displays data in the form of sections..each section contains a master.
Break is used to group the data without changing the format
Master Detail:
•A particular entity is set as master to get detailed table information
•Format is changed
Break:
•Grouping of data
•Format is not changed
37.Difference b/w Pivot,Condition and filter?
Pivot:
Pivot is used to hide or show objects
Condition:
Conditions are used to retrieve data which meets certain criteria
Filter:
Filters are applied for getting required data
38.Describe Charts And Legend?
•Charts are a type of graphic organizer that represents tabular numeric data and/or functions. •In order to turn to chart..the table should contain one measure object…if not the following error is displayed….
•RPT0001:Unable to turn to chart…you should include atleast one measure in X-axis and one variable in Y-axis.
•Legend: Legend gives labels to the chart…
39.Describe Drill Analysis?
Drill:
This is used in complex reports eg: dashboards.
Drill down, drill up (used when there are hierarchies), drill by(to drill with a particular value),drill through .
A duplicate copy is created when we drill the report.
40.Describe Aggregate_Aware?
Aggregate_Aware is a function which determines which tables to use in SQL generation.
Example:@Aggregate_Aware(sum(table1.revenue),sum(table2.revenue))
41.What are different types of filters?
We can apply 4 types of filters to data providers when you build data providers using the Java Report Panel:
1.Predefined Filters
2.Custom Filters
3.Prompts Filters
4.Advanced filters
We can combine all 4 types of filters on a single query
42.Difference B/w Deski and Webi?
The main difference is desktop report is 2-tier architecture come to webi report is 3-tier architecture (communicate with web servers)
43.Differnce B/w crystal and Webi?
The main difference btn the crystal and webi is, webi is prefered for datawarehousing, whereas crystal is prefered for transaction database which involves lots of query and joins.
44. What do prefer an Alias or a context? Why?
A) Alias - A logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins.
A) Context - A context is a rule by which Designer can decide which of two paths to choose when more than one path is possible from one table to another. Contexts can be used to resolve loops in the universe. You can create contexts manually, or cause them to be detected by Designer. When contexts are useful, Designer suggests a list of contexts that you can create.
45.What is join? Explain different types of joins?
A) A relational operation that causes two tables with a common column to be combined into a single table. Designer supports equi-joins, theta joins, outer joins, and shortcut joins.
46.What is a domain? How many are there is a basic set up? What are they?
A) The repository is made up of three domains:
the security domain,
the universe domain, and the document domain.
47.When is the repository created?
A) The repository is created by the general supervisor with the Setup wizard during the first-time use of the product. You can create and use more than one repository, typically to manage multiple sites.
48.Can we have multiple domains? If yes. Purpose of having them?
A) 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 Report problems and corruption. Also, you can reduce the risk that problems corrupt your entire Report.
49.What is BOmain.key?
A) A file that contains the address of the repository's security domain. This file must be distributed to all users who will access the BusinessObjects repository to share universes and documents. By default, the bomain.key is placed in the BusinessObjects\LocData folder on your system.
50.How do you create a user group?
A)
1) In the User pane, click the group in which you want to create a new group.
2) Click on the toolbar.
3) Type a group name, and press the Enter key.