How we will see which trap(Chasm trap or Fantrap) was used
in the Universe ?
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 |
What is diff between InfoView and Zero BOAdmin (ZABO)?
What is a fantrap in business objects?
Explain in detail about type 1?
What services the broadcast agent offers on the server side?
Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?
How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.
Can anybody tell me the difference b/w canned and adhoc reporting?.
What is detailed Object
How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.
1 Answers Cognizant, WinAlliance,
Explain about derived tables?
How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.
What are the Users and Usergroups?