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
- 9013 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 |
Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example
How do you find what type of trap is there by seeing the report?
What is diff between InfoView and Zero BOAdmin (ZABO)?
How do you restrict access to rows of a database?
How to link one location universe to other location universe
How to open a universe with out using the Designer ??
WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?
Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?
What is the degenerated Objects?
What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash
why we use aggregation in lower level
WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT
9 Answers Business Intelligence Analytics, SRA,
Teradata 
