Interested to Buy Any Domain ? << Click Here >> for more details...
How we will see which trap(Chasm trap or Fantrap) was used
in the Universe ?
- 2 Answers
- 9169 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sree
visually we can find out the traps, there is no option is
available in BO designer level.
Fan Trap: it is nothing but One-to-Many joins path is
occured from (fact to Dimension), using aliases we can
resolve the fan trap.
Chasm Trap: it is nothing but Many-to-One join path,
i.e.,single lookup table converging into more than one fact
table is called "chasm trap'. Using context we can resolve
the chasm trap.
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / aanonymous
In universe structure panel,
Organize the dimension tables and fact tables after making the
possible joins. Look at the
joins and cordialities from Dimension tables to Fact table.
If majority of the joins (one-to-many)towards fact from
dimension table consider as Chasm trap.
If majority of the joins away from the Fact table and
towards dimension table(s) consider as Fan trap
If it is Fan trap, Alias is the recommended method to
resolve the loop, otherwise use the context.
We can use either of that or both of them.
| Is This Answer Correct ? | 5 Yes | 6 No |
Can i merge two dataproviders if they do not have common column?
How to Avoid the overlaping the blocks in WEBI.
Explain the difference between detect alias and detect context?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
How to change the order of prompts in universe?
how to create reports on screech?
what is difference between folders and category ?
Example of how the fantraps and chasm traps works?
What is Cartesian product?
hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks
how to restrict null values in webi report?
How to get top 5 rows of a selected column?
Teradata 
