How we will see which trap(Chasm trap or Fantrap) was used
in the Universe ?
- 2 Answers
- 8039 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 |
how can i add two different reports in the same document?
Is there any other repository domains rather than universe, security, document?
what is universe testing(not mention check integrity)
How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?
WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash
How will you know the version of Bo using designer?
4 Answers Tavant Technologies,
I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?
When to use local filter and when to use global filter?
8. How much supervision have you typically received in your previous job?
is it possible to export the webi reports to crystal reports?with out using businessview?
What is the most complex report you have developed. Explain and how did you overcome??? Please give some examples
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Teradata 
