what happens if cardinalities are not resolved?
Answers were Sorted based on User's Feedback
If Cardinalities are not specified between the tables i.e
the relationship between the tables ( 1-1,1-MANY,MANY-MANY)
We get more results at report level more than the actual
result,like a Cartesian product.
We can't detect the Loops & Traps
(Chasam & Fan) Which are mainly detected by the
CARDINALITIES option
so it should be Identified.
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / srinivas
hi
this is srinivas
cardinaliries are called relationship, u given the tables
relationship 1-1,1-many,many-1,many-many relationship
(which is suitable for that area) give the correct
once check the check integrity button
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nagarjuna
If we r not Resolved this then we will not resolve the
loops (contxts,alias).........Nagarjuna
| Is This Answer Correct ? | 0 Yes | 3 No |
WHAT KIND OF TOOL BO IS?
What are steps to be taken care to create a good Universe?
what is performance tunning in BO in report level& designer level?
How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?
What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...
Can anybody tell me what are the tuning problems?
Is it mandatory to give a cardinality ? If cardinality is not given what will happen?
What is difference between webi and infoview?
Which versions are used in the bo dashboard work?
disadvantages of boxi
what is slice & dice?
3 Answers Cognizant, Saama Tech, TCS,
WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?