T.Sreenu

• Jul 2nd, 2014

Alias is to resolve the loop between three tables and one Fact table , context is used to resolve loop between three tables and more than one fact Table

purvanshu

 Profile Answers by purvanshu Questions by purvanshu

• Jan 26th, 2014

Hi.... Hope it is useful..... Alias use to solve Fan Traps problem in Fan Traps problem 3 tables will be participate, table A connected to table B with one-to-many relationship, table B connected to...

Answer Question  Select Best Answer

PRASAD

• May 16th, 2019

Filters applied at Universe objects level restrict data for every user This indicates filters at universe object bring restricted data to micro-cube where the users at report doesnt have control ove...

Aditya

• Feb 10th, 2015

Do the filters created the Universe level do any filtering of data that the Universe level also or they are just created to facilitate common filtering criterias at the report level

Answer Question  Select Best Answer

If we have a user group and we want to give the access to the report from 1990 to 2000. and from that group we want one user to restrict to see the report from 1990 to 1995. Then what to do in BO designer, so that this can be possible( Not in report level).

T.sreenivasulu

• Aug 15th, 2014

Best answer is using row level restriction for 1990 to 1995

vishwanath_bhambure

 Profile Answers by vishwanath_bhambure Questions by vishwanath_bhambure

• Jul 15th, 2014

Restrictions are joined by default by "AND" Clause. So, If user has subscribed to two restriction that two restriction will joined by and for that user. So suppose current user is member of two restri...

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

Expresses the minimum and the 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.

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 19th, 2009

Cardinality describes a join between 2 tables by stating how many rows of one table will match with rows of another table. It is very important to detect join problems and to create the contexts to co...

desaial

 Profile Answers by desaial Questions by desaial

• Jun 26th, 2008

Cardinality means "How many instances of an Entity (on one side of the join) are related to the how many instance of another entity (on the other side of the join)"

Answer Question  Select Best Answer

any body please help me with BO's diffrences

Suresh

• Jun 25th, 2006

Main Diff Bet 5.1 & 6.5v - Cluster Concept:In BO 6.5v architecture ClusterManager & Cluster Nodes are there. "Cluster" means group of Cluster Nodes."Cluster Manager" means group of C...

wassup

 Profile Answers by wassup Questions by wassup

• Mar 29th, 2006

Hi Sithu,I am looking at the PDF document "businessobjects_xi_whats_new.pdf" (goto Page 10) downloaded from the BusinessObjects site. A sample info found on this pdf:----------------------------------...

Answer Question  Select Best Answer

Nidhii

 Profile Answers by Nidhii Questions by Nidhii

• Mar 14th, 2007

U r welcome Pat ;)).. if u have any queries in bo designer or reporter,u can always count on me. Regards,Nidhi

pat.mclean

 Profile Answers by pat.mclean Questions by pat.mclean

• Mar 13th, 2007

Hey Nidhii,Thanks a lot for your contribution.

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

What is joinpath problem?

venkatesh

• Dec 26th, 2014

JOIN PATH PROBLEMS

1)LOOPS
2)TRAPS

Loops can be resolved using 1)alias(can completely solve loops)
2)contexts(can only cover loop,not completely solve the loop)
Traps can be solved by using

1)chasm trap
2)fan trap

muralikrishna1982

 Profile Answers by muralikrishna1982 Questions by muralikrishna1982

• Aug 27th, 2008

The join path problems areee loops, chasmtraps, fantraps..these can be solved by using 1) visualising analysis of schema2) by  using aliases3) by using contexts

Answer Question  Select Best Answer

Can any one tell me the tools and Complete architecture of BOXIR2? and also each tool is used for what purpose?

sagarikaka

 Profile Answers by sagarikaka Questions by sagarikaka

• Jun 24th, 2009

BOXIR2 Tools:1. Business Objects Designer: Enables u to create universes.2. Desktop Intelligence: Allows you to analyze data, perform ad-hoc queries to fetch  new data, and create reports. Often ...

Priyank Bhayani

 Profile Answers by Priyank Bhayani Questions by Priyank Bhayani

• Jul 22nd, 2008

Universe designer is used to create universe which will be used in desktop intelligence to create reports. BO XI is also having an import wizard tool which will be used for taking backup in biar file ...

Answer Question  Select Best Answer

What are Universe Parameters? What does the Parameters tab in Universe Parameters indicate?

sagarikaka

 Profile Answers by sagarikaka Questions by sagarikaka

• Oct 30th, 2008

The Parameter tab in the universe indicates list of SQL parameters that can b set to optimize SQL generation.The parameters file is still used for many RDBMS specific SQL and connection parameters. fo...

sagarikaka

 Profile Answers by sagarikaka Questions by sagarikaka

• Oct 30th, 2008

Universe Parameters are definitions and restrictions that you define for a universe that identify universe and its database connections, specify type of queries that can b run using the universe, and ...

Answer Question  Select Best Answer

An object being tracked in multidimensional analysis; the subject of the analysis. Dimensions are organized into hierarchies.

shailesh.suman

 Profile Answers by shailesh.suman Questions by shailesh.suman

• Aug 15th, 2008

A dimension is an object that is a focus of analysis in a query. A dimension maps to one or more columns or functions in the database that are key to a query. For example Country, Sales Person, Products, or Sales Line.

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 20th, 2007

A Dimension object is typically textual information by which users analyze the numeric measures, such as product, region, or month. A dimension object often comes from the lookup or reference tables w...

Answer Question  Select Best Answer

A join that links two tables by bypassing one or more other tables in the universe.

sreenu

• Jul 2nd, 2014

Shortcut join is a join , It is an alternative path between the tables .
By using shortcut join we can improve the performance of query and decrease the join path.

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 19th, 2009

A. short cut joins are used to improve the query performance at universe level i.e. for performance tuning. Suppose if we have 4 tables A,B,C and D A--->B---->C---->D and there is a chance to...

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

vengi

• Jun 1st, 2012

Shortcut join: direct joins b/w the two tables by eliminating the intermediate tables.......the main purpose of this join is improve the performance of the query

BalamuruganS

 Profile Answers by BalamuruganS Questions by BalamuruganS

• Jun 1st, 2011

Locking of universes:When you are to import a universe , you will be going to File->Import.A dialog box opens where you can browse the universe you want to open.If you double click on the universe ...

Answer Question  Select Best Answer

Tak

• Dec 4th, 2014

You can create Groups in CMC

sharmampooja

 Profile Answers by sharmampooja Questions by sharmampooja

• Apr 28th, 2009

Their is no option to create groups in Designer, you have to use CMS to create groups.RegardsMohit

Answer Question  Select Best Answer

nanis38

 Profile Answers by nanis38 Questions by nanis38

• Jun 16th, 2011

We can also find out by using DataProvider() function at report level

sumesh

• Mar 7th, 2007

Go to View -->structure...Here you can find the data providers name in Map tab..

Answer Question  Select Best Answer

Mohd Sarim

• Jul 13th, 2011

Info view is nothing but another name of web intelligence. we also call it BO thin client.

DeskI is thick client as we need software installed on the system to access BO reports etc whereas in case of WebI the BO installed on the server and we need to access it through our browser

Kumaresh Goplsamy

 Profile Answers by Kumaresh Goplsamy Questions by Kumaresh Goplsamy

• Jul 25th, 2007

Infoview is a portal to access the Business Objects in Web intelligence.? Business Objects???????????????????????????????????????????????????????????????? ??? web intelligence1.Multiple data providers...

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

A mapping of the data structure found in databases: tables, columns, joins, etc. A universe, which is made up of classes, objects, and conditions, can represent any specific application, system, or group of users.

amaresh1981

 Profile Answers by amaresh1981 Questions by amaresh1981

• Sep 9th, 2009

An universe is an symanteic layer between the user and the Designer which contains connection of a database

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 21st, 2007

Universe is a Semantice layer that maps the data structure found in databases (tables, columns, views..etc) to Business Terms.Cheers,Ravi Kumar Garreravi_kumar_garre@yahoo.co.in

Answer Question  Select Best Answer