Page1
1.How to select different data providers in business objects?
Once you have your report generated, right click in the left window (your variables) click on "New Data Provider" follow the wizard. & you are done.
If trying to use diff. data provider for different reports, after creating 1 report, right click on the Report1 tab located at the bottom, click insert new then the procedure is same to add data provider.
2.When we use aggregate awareness function in designer?
In order to solve fan trap in business objects we either create alias table or aggregate awareness function Through aggregate navigation we can also select the compatible as well as incompatible objects
Ex:-year, quarter, month, week, and day
Year:-quarter, month, week, and day are compatible objects
Quarter:-year  class is incompatible and month, week, day is compatible.
We specify the objects in descending order
3.What is Business objects Repository?
It is nothing but metadata.
4.Is there any other repository domain rather than...
There are only three main Domains Security, Universe and document. You can have multiple Universe and Documents domains in a repository but only one Security domain.
5.What is a Bo repository
· Its A Semantic Layer Which Stores The Bo Users N Their Privileges
· 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.
· Repository is data accounts which contain three domains in each one type. You can create the repository any where .the security domain has the user security info and other domains address. You can have more than one repository but you can use which one u specifying on the time of login. The address info of the security domains is stored in the .key file if WebI it’s in the Bomain.keyfor more refer the cindi howson book and visit her web www. Askcindi.com
· BO repository is a set of db tables which holds the metadata information. This Bo repository is divided in to 3 domains Security, universe, and document domain. This metadata holds all the information related to users groups their privileges...........except the "supervisor" this is the super user of Bo rep.the supervisor info is stored BOMain.key which is stored in default theme dir of Bo.
· BO Repository is a set of related data structures of BO stored in a database. It contains tables of Security, Documents and Universe Domains
· Generally Repository is the Metadata
BO 5.0 Repository create/maintain 50 tables, they are distributed as follows
25 tables for Security domain
24 Table for Universe domain
1 Table for Document Domain
· in 6.5.1 repository
25 tables in sec.domin
1 table in doc domain
31 tables in uni domain
It is a metadata
· Can some one provide the BO XI rel 2 repository Domains (Number of tables for each domain)...
A context is simply a list of joins denoting a path between tables.
Contexts are set to identify alternative routes in the universe structure.
BusinessObjects detects a context for each alternative route.
Contexts identify tables which are incompatible within the same SELECT statement - because the wrong results will be produced.
6.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, and 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.
7.When is the Repository created?
In 5i/6i versions after installing the software, whereas in Xi version a repository is created at the time of installation.
8.Can we have multiple domains?
Yes. (Security domain can not be multiple).
9.How do you restrict access to rows of a database?
In XI version it can be do
10. In a report can we hide a particular object?
Yes we can show/hide a particular object in a table by using the pivot tab of the format table dialog box
11. Difference between compatible and incompatible objects?
- When an object is at the same or higher level of aggregation as the table, it is compatible with the table.
- When an object is at a lower level of aggregation than the table (or if it is not at all related to the table), it is incompatible with the table.
- We can select or choose compatible n incompatible objects through aggregator navigation in the designer. With this method the performance increases tremendously. Instead of checking for each n every object only the compatible objects are only looked for aggregate awareness. Year:-month, quarter, week, day are compatible but customer class is incompatible
12. Can you please clarify the difference between compatible and incompatible objects? When we will use these two?
When you are defining Aggregate tables in Universe design, you need to create hierarchies for aggregated objects, for that you need to make the relative objects incompatible (the objects which are of lower level of aggregation -- not of hierarchy you have Year, Quarter, Month, Day as a hierarchy, while aggregation, you need to define as follows Year - Quarter, Month, Day Compatibles
Quarter - Month, Day Compatibles, Year Non-compatible
Month - Day Compatible, Year, Quarter Non-compatible
13. Detail
Provide a description of a dimension, but are not the focus
For analysis. For example Phone Number
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.
14. Measure
Concvey numeric information which is used to quantify a Dimension object. For ex: Sales Revenue
15. What is an object?
- It is an instance of class, its nothing but an entity.
- In Business Objects products an object is a named component in a universe that
- Represents a column or function in a database.
- Object qualification represents what kind of object is that, usually we have three types of object qualifiers they are measure, dimension, detailed.
- An object is a named component that maps to data or a derivation of data in the Database. The name of an object should be drawn from the business vocabulary of the targeted user group. For example, objects used in a universe used by a Product manager could be Product, Life Cycle, or Release Date. A universe Used by a financial analyst could contain objects such as Profit Margin, and Return on Investment.
- In Designer, objects are qualified as one of three types: dimension, detail, or Measure.
- Object qualification represents what kind of object is that, usually we have three types of object qualifiers they are measure, dimension, detailed.
16. 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.
17. How does a context resolve a loop?
A context resolves a loop by defining a set of joins that specify one specific path
Through tables in a loop. It ensures that joins are not included from different paths
Within the same SQL query.
18. While resolving loops, how to decide whether alias or context to be used? Describe
19. What is the use of alias and context? Which is the better for solving the loops? Why? Why we use alias and why we use context?
20. What is a Loop?
A loop is a set of joins that defines a closed path through a set of tables in a Schema. Loops occur when joins form multiple paths between lookup tables
21. 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.
22. How does an alias break a loop?
An alias breaks a loop by using the same table twice in the same query for a Different Purpose.
The alias is identical to the base table with a different name. The data in the alias is exactly the same as the original table, but the different Name “tricks” SQL into accepting that you are using two different tables.
23. Create an alias to break a loop caused by shared lookup tables
A sales database holds information about customers living in different countries.
These customers can place orders for goods that can be delivered by a number
Of couriers or shipping companies.
24. Determining when an alias is not appropriate to break a loop
Creating an alias to resolve the loop described above is not the optimal solution.
In this case, the use of contexts is a better solution. The following example
Describes why aliases are not appropriate, and why contexts are a better solution
In this case.
If you try to identify the lookup table used for more than one purpose, it is not clear
If it is the PRODUCTS table, or the CUSTOMERS table.
25. What is a context?
Contexts are a collection of joins which provide a valid query path for Business Objects and Web Intelligence to generate SQL.