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 |
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
7.what is data mart?
I have a report with some hyperlinks,any issue will i get when i migrate this report?
What are the steps to do to use alerts in bo?
How many universe dfi you create if you have 2 years of experience in BO
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
how to add duplicte rows to the existing report in webi ?
what are the disadvantages of alias?
how to solve the incompatible objects and how they are formed actually.
how to create dashboard reports
what are they different types of report in BO?
I need to develop cross tab in format: Values D E F A 1 3 4 B 2 5 8 C 9 8 10 My problem is values in header I am able to do same in WEBI how to manipulate same in deski? Plz Help