arunabala

 Profile Answers by arunabala Questions by arunabala

• Feb 26th, 2008

HiSlicing and dicing means switching the position of data in the report, two swap two variables horizontally, we can swap rows to columns or columns to rows,   very easy to do master detail reports.

raysgowda

• Feb 26th, 2007

Slice and Dice is used for extensive data analysis.

Answer Question  Select Best Answer

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 21st, 2007

Did u mean that Measure objects??Ravi Kumar Garre

sar

• Apr 23rd, 2007

Most important, Backup and maintain versions

Answer Question  Select Best Answer

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 need to resolve loops which occur in the joins using aliases or contexts. You can conclude this phase by testing the integrity of the overall structure.During...

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 21st, 2007

Universe Design as follows:Define Parameters -> Insert Database Schema (tables, columns..etc)->Make the Joins->Resolve the loops->create classes and Objects->Hierarchies.Then test the universe for integraty.Cheers,Ravi Kumar Garreravi_kumar_garre@yahoo.co.in

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 27th, 2006

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

Answer Question  Select Best Answer

A work mode whereby a designer creates universes in an environment with a repository. The mode in which a universe is saved determines whether other designers are able to access it. By default, a universe is saved in the mode in which the designer is already working.

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 20th, 2007

Within BusinessObjects enterprise, user names can be authenticated against one of more security databases. The default authentication source is Enterprise. However, if your company uses Windows NT, for example then NT user name and password can be used to log into Designer. Cheers,Ravi Kumar Garre

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 30th, 2006

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.Cheers,Sithu

Answer Question  Select Best Answer

An object qualified as a detail provides descriptive data about a dimension object. A detail object cannot be used in drill down analysis.

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 20th, 2007

A Detail object provides additional information about a particular dimension. A Customer dimension, age, fax, phone number, street address and direct mail are typical details. Details and attributes m...

sithu

 Profile Answers by sithu Questions by sithu

• Apr 19th, 2006

Defined role that object takes when used in the Query panel. You can qualify an object as being one of three types:DimensionDetail Measurel detail objects holds more information about you measure and dimension, but you can't drill that based on your detail objectsCheers,Sithu, sithusithu@hotmail.com

Answer Question  Select Best Answer

Set of parameters that provides access to an RDBMS. These parameters include system information such as the data account, user identification, and path to the database. Designer provides three types of connections: secured, shared, and personal.

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 13th, 2007

BO Designer supports three different types of connections, each denoted with a unique symbol in the list of connections:1. Personnal connections that users may create for freehand SQL or that universe...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 27th, 2006

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.Cheers,Sithu

Answer Question  Select Best Answer

A situation in which a query includes two or more tables that are not linked by a join. If executed, this type of query retrieves all possible combinations between each table and may lead to inaccurate results.

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 13th, 2007

Table A having m records and Table B having n records then the cartesian prodcut is mXn. Regards,Ravi Kumar Garreravi_kumar_garre@yahoo.co.in

Reen

• Oct 11th, 2007

Cartesan product is the result of a query when the two tables are not joined by any type of join. All the possible combinations of one table are displayed with the other table just like a cartesan product in algebra

Answer Question  Select Best Answer

sudipta saha

• Sep 24th, 2007

Derived tables are mainly created to have some precalculations done so that they save processing time .Complex calculations involving huge amounts of data at report level reduces the performance of th...

Answer Question  Select Best Answer

jgd.ramesh

• Aug 15th, 2007

They are two type of security in BO, first one row level security and another one column level security, this is to hide object?any doubt contact with me jgd . ramesh @ gmail . com

Kumaresh Goplsamy

 Profile Answers by Kumaresh Goplsamy Questions by Kumaresh Goplsamy

• Jul 25th, 2007

There are four security level used in BO1.Database level security2.Row level security3.Table mapping4.Security table---------------------------Thanks & regards,Kumaresh Gopalsamy.

Answer Question  Select Best Answer

Muthukrishnan

• Aug 7th, 2007

To enhance the performance of the universe, we have to do the following:1) Keep universe light,2) Deselect multiple SQL statements for each measure options,3) Try to avoid outer joins,4) Use off-line ...

Tushar

• Feb 16th, 2007

I agreed with Ravi what he said except his 4th point. Short cut join privide shortest path and and gives result in shortest time but Business Objects itself suggest using shortcut join is not good practice.

Answer Question  Select Best Answer

Kumaresh Goplsamy

 Profile Answers by Kumaresh Goplsamy Questions by Kumaresh Goplsamy

• Jul 25th, 2007

Hi,   Aggregate table is a pre defined table.calculate the aggregates and store the values in one table.Instead you ask query to generate aggregate every time you just give reference to...

Sravan Gopisetty

• Sep 14th, 2006

Hi,Is that Aggregator Transformation or Aggregator Tables.If it is Aggregator Transformation then it CALCULATES the summery values like SumSAl,AVGSAL,MAXSAL,MINSAL FOR EACH GROUP WISE.FOR EXAMPLE...

Answer Question  Select Best Answer

Kumaresh Goplsamy

 Profile Answers by Kumaresh Goplsamy Questions by Kumaresh Goplsamy

• Jul 25th, 2007

Hi,universe is provided with default strategy  also known as built in strategy.if you want to create new strategy, edit the .SBO file and mention your strategy ,and this strategy  ...

mayuri

• May 4th, 2006

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

Answer Question  Select Best Answer

Mark

• Jul 16th, 2007

1. What is a universe? A universe is a semantic layer which allows a designer to provide a meaningful interface for reporters to build reports and other queries against.2. Analysis in business objects...

mahesh patil

• Dec 10th, 2006

4.how u check the universeans.there is a option in the toll bar that is check integrity.which checks the all types of joins,context,cardnality,loops,etc.u click on that option it automatically checks ...

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

fani_ece

• Jun 22nd, 2007

Go to help and click About Designer in help, you will find it.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 4th, 2006

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 Cheers Sithu  

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

Sunil Dadheech

• Jun 2nd, 2007

Steps are as follows:1. Set up the Performance Manager(PM) Repository.2. At PM home page, Add universe available in the repository.  Important Point  to take care of is, All measur...

Nayef Almiseher

• Dec 4th, 2006

Hi ,Before started with Dashboard you have to build an Universe using BO Designer?and you have to know some of SQL statments . I think its better to get Training from BO in DashBoard because it's not easy like creating Reports using BO Reporter .Eng.Nayef Saudi Arabia

Answer Question  Select Best Answer

muni krishna reddy

• Jun 1st, 2007

BO XI archi. is completely different from its previous versions. It was completely built on crystal reports archi. In XI we don't save docs in repository. we will save them as physical data known as f...

Latha03

 Profile Answers by Latha03 Questions by Latha03

• Jan 25th, 2007

In BO 6.5 either subordinates(Designer,Reporter) or Supervisor can have more or less rights independent of their positions.In BO XIR2 the rights are inherited from the supervisor to the subordinates(Designer, Reporter).

Answer Question  Select Best Answer

sar

• Apr 23rd, 2007

If you just need the query.select product,sum(case when date > 'xxxx' and date 'xxxx' and date

Answer Question  Select Best Answer

sar

• Apr 23rd, 2007

Additionally-- Follow naming convention -- Objects and conditions in a class should be either hierarchial or alphabetical-- Classes/ Sub Classes should be logical-- Organize the schema, no clutters of joins 

Kumar Ranu

• Apr 16th, 2007

I would like to add...Universe contains Dimensions and facts.These are linked with joins so there must be indexes on the dimensions table's columns and if nessesary fact table's columns.Mostly...

Answer Question  Select Best Answer