The secured connections are used to access universe or document. It can be used by several users. Shared connection This connection do not having the connection with repository. so you do not import or export the universe.the shared connection... Read More

Local Filter >>Specific to a block (Table/cross tab/ chart etc..) Global Filter >> Specific to a TAB in a report If a report has multiple Tabs, each can have its own Local and Global filters. Read More

We can set the predefined condition in the universe level. In the task bar of the designer there is an icon for filtering. Just click on the icon. It asks for the condition name. After giving the name for the condition type the sql for that... Read More

Index awareness is the ability to take advantage of the indexes on key columns to speed data retrieval. Read More

if you have source system > source location field. double click source system > edit properties menu will display, click properties tab and click edit you will get query pane there you pull down source location object in conditon pane and... Read More

It is also called INNER JOIN Its based on the equality between the coloumn from two tables Read More

Personal connections are used to access resources such as universe or document Read More

If your database consist all dates something like 01/02/2000 or 01-Feb-2000, you will need to break the date field into year, qtr,month & if required date. to do this, create a class named TIME, under that create new object, in it’s select... Read More

BO automatically generates the SQL query when objects are selected into query panel. When you run the query, the query is processed to database based on your connectivity. for ex: If you run query using, Local Machine Full Client (BO reporter),... Read More

Aggregate awareness is a term that describes the ability of a universe to make use of aggregate tables in a database. These are tables that contain precalculated data. You can use a function called @Aggregate_Aware in the Select statement for an... Read More

Short cut join joins the two tables which r already in a path.SCJ skips the intermmediate tables and joins the table which are already in the common path, using SCJ increases thge performance of the query bcoz the no of tables in the query... Read More

In DESIGNER Level 1)eliminate the unnecessory joins 2)use conditions as much as at the database level 3)edit the SQL query in the Query Panel as per requirment In REPORTER level 1)eliminate the filters as much as possible 2)try to... Read More

The qualification of an object reveals how it can be used in multidimensional analysis. An object can be qualified as a dimension, a detail, or a measure. In the Universe window, the symbol beside each object indicates its qualification: a ... Read More

1.instead of selecting standard report format we can select the template in which we wish to fgenerate a report. for ex:-if we want our report to be in cross-tab format we can select that template. templates are very helpful bcoz we can select the... Read More

The secured connections are used to access universe or document that may be restricted or confidential Read More

This holds the logical arrangement of facts/diemensions and mesures When General supervisor creates repository for BO, it creates 3 domains by default and one among is Universe domain. This holds all the universes created by the designer... Read More

Insert a user object 1 Select the User Objects command from the Insert menu. The Insert User Objects dialog box is displayed. 2 Click a user object file. A user object file has a . udo extension 3 Click the Open button. Read More

The design method consists of two major phases. During the first phase, you create the underlying database structure of your universe. This structure includes the tables and columns of a database and the joins by which they are linked. You may... Read More

Atleast one object in the class must be present in the other class so that they can have a join n ofcourse the datatypes. Read More

1.each n every object n class must be given description so that it is very clear to non technical users also n each n every object must me given a understandable clear name so that by just looking at that one can be able to find out whether it is a... Read More

We have securities in business objects Like 1. Windows authentication 2.RDBMS securities 3.supervisor level securities, ie User name/ password Read More

I b’live that you know that Contexts are used to avoid Loops in Universe Design. To create context : goto Tools --> Detect Loops, BO will detect loops if there are any & will suggest the context candidate (something like Sales, Costs... Read More

Creating a filter in designer is different from creatind a filter in business object if u create a filter in designer it can acessible to all the reports ur r using i’e,it can used for further applications where as creatin a filter vin... Read More

Actually, I wanted to design a Test Plan for Universe testing. Something similar to any other s/w application tesing plan. for that I wanted to know if someone is using any standerd methodology in aspect of Quality Assurance & Control. We are... Read More

Guidelines are provided in the Universe guide: Here is the Summary: 1) Modify the array fetch size in SBO file 2) Assign table weights and change the default order of the tables in a query by changing parameter in PRM file 3) Use shorcut joins... Read More

Using quick design wizard for developing the universe will invoke the built-in strategy Read More

Functional Differences : 1.BusinessObjects client needs to be installed on every PC from where you want to build / access reports. WebI needs just a browser & URL(of the server from where it will access BO). 2.BOMAIN.Key file needs to be... Read More

No, these are antonyms Read More

Cardinality expresses the minimum and maximum number of instances of an entity B that can be associated with an instance of an entity A. The minimum and the maximum number of instances can be equal to 0, 1, or N. Read More

A Cartesian join will get you a Cartesian product. A Cartesian join is when you join every row of one table to every row of another table. You can also get one by joining every row of a table to every row of itself. Read More

A connection is a set of parameters that provides access to an RDBMS. These parameters include system information such as the data account, user identification, and the path to the database. Read More

Enterprise mode means that you are working in an environment with a repository. Workgroup mode means that you are working without a repository. The mode in which you save your universe determines whether other designers are able to access them. Read More

A series of dimensions used for analysis based on user requierments Read More

A list of values contains the data values associated with an object. These data values can originate from a corporate database, or a flat file such as a text file or Excel file. In Designer you create a list of values by running a query from the... Read More

Loop is a logical and pictorial representation of tables joined in such a way that the join’s path begin and end with the same table. Usually such a table would return less number of rows and it is usually the intersection condition values. ... Read More

An object derived from aggregate function, that is know as mesure object Read More

In Object oriented programming, an object is termed as aninstance of a class Object is a named component. Its map the data from database. Read More

Theta join?A theta join is created when the data in two fields from two tables is related via some comparison operator other than equals (=). For example, a not-equal join relates data using the not equal operator (<>). For example, suppose you... Read More

Restrict Top 26 Rows: Depends on how you want to do it. In a report: Drag the Dimention and measures into report. Click on the Dimention object and use the RANK button on the tool bar. you can specify the the Top 26 or Bottom(Depending on the... Read More

A strategy is a script that automatically extracts structural information from a database. Designer provides a number of default strategies you can use. These are strategies for extracting joins, detecting cardinalities, and creating default... Read More

Insert tables in the Structure pane 1 Select the Tables command from the Insert menu. 2 In the Table Browser, click the tables you want to add to the universe structure. To select several contiguous tables, hold down the Shift key, then click the... Read More

A component with in a class that groups the object Read More

Designer lets you save universes in either enterprise or workgroup mode. Enterprise mode means that you are working in an environment with a repository. Workgroup mode means that you are working without a repository. The mode in which you save your... Read More

Measure objects are the objects which have facts i.e all $ amounts a dimension object cannot be calculated with another dim object in order to have a seperate identity for $ amounts we define as measure objects just create an object for ex... Read More

Business Objects deals with databases, for every universe you need to specify a database connection. flat files dont have the database format so you’ll need to convert them into some database. to do that, you will need to write a procedure... Read More

Tfollowing steps to link two diffrent universes!!!!!!!!!! 1>1st export one universe in desginer and then reimport it before linking it. 2>Open other universe. 3>From file menu in designer click on parameter and then select link tab to... Read More

Slice & Dice is facility in BO. we can enables change the positions of data in Report..here in Bo we slice & dice panel by using this we can create cross tables and masterdetails tables. Read More

Select @@version is the command that will give the said details Read More

Select the component business object DesignerNow it will prompt for userid/password/security domainYou will find a Help button, click that and find out what ever you want Read More

# pragma pack preprocessor dirictive specifies the byte boundary for packing members of c structures.syntax: #pragma pack(n) Read More

Smart Matching columns Manually you can link Read More

If the question is how to link from one report to another...then OpenDocument function can be used. You can do this in different methods: In ASP environment.. Universe level: create an object with Object format: HTML option enabled, SELECT:<A... Read More

Broadcast agent is used for scheduling or bursting the reports. thru this,you can schedule your reports so that end-users can access reports thru internet. you have broadcast administration console here thru which,you can schedule reports and... Read More

1)make the joins with optimization 2) reduce the creation userobjects more in the universe 3)class should not be more than 60 4)try to use aggreateware on measure objects Read More

Drill up : UP-one level Drill down: DOWN-one level Drill by : selection of level Hierarchy Drill trough : Hirearchy to another Hirearchy Read More

An alias is a logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. In some cases, more than one alias may be necessary for a given table. Read More

A class is a logical grouping of objects within a universe. In general, the name of a class reflects a business concept that conveys the category or type of objects. For example, in a universe pertaining to human resources, one class might be... Read More

Lets you create a condition. The conditions that you define appear within the Universe window. From the Query Panel, a user can drag the conditions from the Classes and Objects box to the Conditions box. Read More

Defined role that object takes when used in the Query panel. You can qualify an object as being one of three types: Dimension Detail Measurel detail objects holds more information about you measure and dimension, but you can’t drill that... Read More

1 Double-click the object in the Universe window. The Edit Properties dialog box is displayed. 2 In the Definition tab, change the object’s type, if necessary. 3 Click the Properties tab. 4 In the Qualification box, click the Dimension radio... Read More

There can be 3 types of Drill Analysis- Drill Down,Drill Up and Drill Through. Within the same universe one can Drill Up/Down like Country-State-City;of course with facts that relate to the same grain. A Drill through is possible when we can link... Read More

The designer can design the universe in offline mode for that you need to login at least once The mode that connects you to access your locally saved Universe, Documents and Data when you are unable to connect to the repository is termed as... Read More

Outer Join - method of retreiving selected rows from one table that doesn’t match rows with the other table. Read More

The values what exactly the user need is query Query is an SQL statement written against the database form which you want to fetch and present the data Read More

If you click the File/New starts Quick Design wizard check box in the General tab (Tools menu, Options command) the New command automatically launches the Quick Design wizard. Read More

Right click on any object,go to the properties.specify the query in select and put the next query in where clause, like select COLNAME from TABNAME1 where COLNAME IN(select colname2 from tab2) Read More

Designer It is one of the business object?s components It is used to create universes It is used to define measures/metrics It is used to do the calculations Designer is one of the business objects product. It is used to... Read More

Question : Can anyone enlighten me: While connecting 2 subject oriented data mart for example SALES & MARKETING, thru common key, but the common dimensional table name alone (not the structure or columns in the table) is different say ... Read More

Some more differences: ---With Webi 6.5, use of multiple data providers are allowed.....but the the only problem is that there is no syncronisation..i.e, Data providers cannot be linked! ---with 6.5, infact from 6.1 onwards, you can directly save a... Read More

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... Read More

All the document informations are stored here, Read More

Relational operation that causes two tables Join is a relational operation that allows two tables with a common domain or column to be joined into a single table to fetch meaningfully combination of data. Joins avoids the occurrence of... Read More