Answer Posted / krish
Chasam Trap:
chasm trap means many-to-one and one-to-many join relation
converge on to a single lookup table, because of this we
get incorrect results i.e., cartision product, We will
resolved by using some times alias, some times context,
some times shortcut join and check mutiple context for each
measures option.
Fan Trap:
Fantrap means one-to-many and one-to-many join relation of
the tables it is detected by visval analysis, because of
this we get incorrect results i.e., cartision product,
We will resolved by using some times alias, some times
shortcut join and check mutiple sql statements for each
measures option.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is difference between custom hierarchy and report based hierarchy?
How to create Index to the table in the universe designer and how it improves the Query performence
What are the data types present in bo? What happens if we implement view in the designer and report?
Can we create universe with no cache??
what are the day to day activities of BO administrator ?
What is the dense rank?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What are the join problems comes appart from loop,chasm & fan Traps
what is universe null
Explain about alerts in bos, under what situation we need to use alerts?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Differences between business objects and web intelligence reports?
Explain in detail about type 1?
What would you consider as your biggest achievement and why?