rakesh roshan jha

• Oct 10th, 2005

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)

Answer Question  Select Best Answer

SURROGET KEY.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 9th, 2006

Smart Matching columnsManually you can linkCheers,Sithu

Answer Question  Select Best Answer

Ravi

• Dec 8th, 2005

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

Answer Question  Select Best Answer

mahudes

 Profile Answers by mahudes Questions by mahudes

• Mar 30th, 2006

hi 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 ge...

Answer Question  Select Best Answer

Srinivas

• Mar 24th, 2006

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

Answer Question  Select Best Answer

pat.mclean

 Profile Answers by pat.mclean Questions by pat.mclean

• May 23rd, 2006

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 a...

Answer Question  Select Best Answer

pat.mclean

 Profile Answers by pat.mclean Questions by pat.mclean

• May 31st, 2006

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 co...

Answer Question  Select Best Answer

pinki

• Jul 22nd, 2006

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

Answer Question  Select Best Answer

Siva Kumar Rachaputi

• Sep 2nd, 2006

Hi,I think you can create a dimension object with decode statement.decode(code,code_val1,'National',code_val2,'International',code_val3,'International'....)

Answer Question  Select Best Answer

barbie

• Oct 6th, 2006

Cube :  Loal structure to hold the data returned by a queryschema:  graphical representation of databaseuniverse: symantic layer that isolates end user from  the comlex structure of databse

Answer Question  Select Best Answer

Sunil

• Jun 3rd, 2007

You need to follow below steps:1. At PM home page, Create calender to associate with the measures.2. Select Dimensions.3. Create Metrix, using Dimensions and Measures associated with the cal...

Answer Question  Select Best Answer

A join based on the equality between the values in the column of one table and the values in the column of another. Because the same column is present in both tables, the join synchronizes the two tables.

xinx0626

 Profile Answers by xinx0626 Questions by xinx0626

• Jun 28th, 2006

It is also called INNER JOIN

Xinx0626

• Jun 28th, 2006

It is also called INNER JOIN

Answer Question  Select Best Answer

A situation that occurs when more than one path exists from one table to another in the universe.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 27th, 2006

A loop is a situation that occurs when more than one path exists from one table to another. Loops result in ambiguity in the design of a universe. Designer enables you to identify loops in one of two ways:aliesContextsCheers,Sithu

SM

• Oct 4th, 2005

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.Loops are resolved by Alias Table.

Answer Question  Select Best Answer

A component that maps to data or a derivation of data in the database. For the purposes of multidimensional analysis, an object can be qualified as a dimension, detail, or measure. Objects are grouped into classes.

kkishore

• Oct 21st, 2005

Object is nothing but templet of a class

rrl

 Profile Answers by rrl Questions by rrl

• Oct 15th, 2005

In Object oriented programming, an object is termed as aninstance of a class

Answer Question  Select Best Answer

The work mode appropriate for a networked environment in which the general supervisor has set up a repository.

rakesh

• Jan 29th, 2007

Online mode means working with u r repositoryit means that u have been logged on to u repository and u r using that universe

Answer Question  Select Best Answer

A centralized set of relational data structures stored in a database. It enables BusinessObjects users to share resources in a controlled and secured environment. The repository is made up of three domains: the security domain, the universe domain, and the document domain.

chaitanya

• Jun 27th, 2007

Repository is nothing but metadata. It contains 3 domains security, universe and document. A repository has only one security domain.

Answer Question  Select Best Answer

Scripts that automatically extract structural information about tables, columns, joins, or cardinalities from a database. Designer provides default strategies but a designer can also create strategies. These are referred to as external strategies.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 27th, 2006

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, dete...

pavan

• Dec 9th, 2005

external

Answer Question  Select Best Answer

The graphical component within the main Designer window that lets you create the classes and objects of the universe from the tables and columns of a database.

Nithyadharmaraj

• Apr 10th, 2007

Table Browser is an independent window that displays the table available in the connected database.You can insert the tables into structure pane by double clicking the tables in the table browser r by...

Answer Question  Select Best Answer

A join that links tables based on a relationship other than equality between two columns.

Murali

• Apr 30th, 2006

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 e...

Mahender

• Mar 2nd, 2006

Joining the fileds using the the between operatoreg:agerange.....to maxage and minageMahiiii

Answer Question  Select Best Answer

Designer is a BusinessObjects IS module used by universe designers to create and maintain universes. Universes are the semantic layer that isolates end users from the technical issues of the database structure. Universe designers can distribute universes to end users by moving them as files through the file system, or by exporting them to the repository.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 4th, 2006

DesignerIt is one of the business object?s componentsIt is used to create universesIt is used to define measures/metricsIt is used to do the calculationsSithu

senkumar79

 Profile Answers by senkumar79 Questions by senkumar79

• Oct 5th, 2005

Its a mapping of business requirements with the database structures in the database.

Answer Question  Select Best Answer