Answer Posted / gokulakrishnan
Actually FAN TRAP is a problem that occurs in Universe
Level. Loop occurs while we design the universe.
Two Types of Loop Problem:
1) FANTRAP PROBLEM solved by ALIAS METHOD:
Definition: Two One-to-many table link eachother is in turn
linked another one-to-many table.
2) CHASM TRAP PROBLEM solved by CONTEXT METHOD:
Definition: Two Many-to-one table converges on one single
lookup table.
Loop can be detected while INTEGRITY CHECK is done. An
option is there as "Check for LOOPS" available. By "Detect
Loop" we can choose what to be applied for solving the loop.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the profile and package?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Explain is there any default username & pwd for bo designer & supervisor?
what is document design in boxi,have u participate in that
What is the difference between datawarehousing and businessintelligence?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
What are the steps to be taken to schedule the report?
When we use aggregate awareness function in designer?
Did you face any problems while creating reports? Name? Solutions?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Explain what are the steps to be taken to schedule the report?
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain when we use aggregate awareness function in designer?