Is it mandatory to give a cardinality ? If cardinality is not given what will

Is it mandatory to give a cardinality ? If cardinality is
not given what will happen?

Question Posted / vinod3035

4 Answers
11261 Views
Infotech, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Is it mandatory to give a cardinality ? If cardinality is not given what will happen?..

Cardinalities express the maximum number of instances of an
entity A that can be associated to corresponding instances
in another entity B.

Cardinalities need to be defined while setting up joins in
a universe. If not, we encounter join path problems such
as loops and traps, and joining tables will result in
Cartesian products.

Is This Answer Correct ?

3 Yes

2 No

Is it mandatory to give a cardinality ? If cardinality is not given what will happen?..

Answer / rndp99

yes we have to give cardinality to avoid join path problems
and to avoid cartesian product

Is This Answer Correct ?

2 Yes

1 No

Is it mandatory to give a cardinality ? If cardinality is not given what will happen?..

Answer / manik

If cardinality not set between table in universe we got error while we run report "without cardinality"

Is This Answer Correct ?

0 Yes

0 No

Is it mandatory to give a cardinality ? If cardinality is not given what will happen?..

Answer / guest

Yes. If the cardinalities are not set, we cannot detect
loops.

Is This Answer Correct ?

1 Yes

3 No

Post New Answer

More Business Objects Interview Questions

what is meant by slowly changing dimensions?

3 Answers TCS,

I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)

3 Answers

Any one suggest me best SAP Business Objects XI Online Training institute from India

2 Answers Aetna,

i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?

2 Answers

What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...

7 Answers TCS,

What is the prm file ? can anybody explain me ?

2 Answers

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

0 Answers HCL,

What is the difference between Thin client & thick client?

5 Answers

Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu

2 Answers Infosys,

what is the difference between Ranking and sort-out in bo?

2 Answers iNautix, TCS,

how to overcome overflow of data in a report

6 Answers

I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data

2 Answers

For more Business Objects Interview Questions Click Here