Interested to Buy Any Domain ? << Click Here >> for more details...
Example of how the fantraps and chasm traps works?
- 1 Answers
- 14714 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / abdul
Chasm trap and Fan Traps are the loops which will occur
while ditecting loops.
Examples of these are:
Chasm Trap:
Orders
Customer <
Sales
When one dimention is having one to many relations with two
diffrent facts then this loop will occur. To resolve this
loop we have to use Context to chose the right path for the
reports to avoid multiple SQL statements.
Fan Tap:
Customer -> orders -> orderlines.
When one customer dimention is having one to many relation
with orders and then again orders is having one to many to
relation with orderlines then the loop will occure. To
resolve this we have to use aliase. Name the second table
oreders with some other alias name then link with third
table. Ensure to remove the link between 2nd and 3rd tables.
Hope this will answer your question.
Thanks,
Abdul
| Is This Answer Correct ? | 15 Yes | 10 No |
Post New Answer View All Answers
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
What is top business?
What sort of existing documents should business analysts refer to when starting on a new project?
What is Indexing? how did u implement indexing?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
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:
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
How to restrict password to a user while sending a document in .pdf format
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Can we create universe with no cache??
Can Bo generates the Report from the cubical data Explain?
Explain about a time when you discovered a more efficient way to do a work task?
