How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?

How we will see which trap(Chasm trap or Fantrap) was used
in the Universe ?

Question Posted / hemalatha.kondari

2 Answers
9074 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?..

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

How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?..

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

Post New Answer

More Business Objects Interview Questions

What is the difference between the prompt and cascading prompt

2 Answers

Shall we connect to the oltp systems directly .,

2 Answers iNautix,

What is user docs and how to use this option in bo?

1 Answers Bank of Baroda,

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:<servername>/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

0 Answers

how do u implement dense rank in bo reports?

2 Answers CTS,

Pls Explain about the different between 6.5 & Xi R2

2 Answers IBM,

WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?

2 Answers PCS,

What is the use of Surrogate Key in BO?

2 Answers CTS, IBM,

Please anybody tell me Is Data integration And ETL programming is same..? Thanks in advance....

3 Answers

Have you worked with multiple data sources? If yes. How do you link them?