Example of how the fantraps and chasm traps works?
Answer / 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 |
We can have two separate installations of BOE XI 3.1 on a single server?
2 table is there , thats column is different name but data type is same, 2 tables values are same. how to you findout both values are same?
is it possible to export the webi reports to crystal reports?with out using businessview?
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?
What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash
wat is report linking in BO..I know that 2 reports can be linked in BO with the help of writing a HTML code .But how. wat s the code.can u give me the example of code taking e fashion as the simple univers data provider.
Explain about a tricky situation for which you found a very simple solution?
what is prompt? Cascading prompt? Syntax
Explain what are the measure objects?
When we r going for Short_cut join & It's Resolution??? Plz provide one scenario??
how to restrict null values in webi report?
Report have 10000 records,how to restrict the end user to 1000 Records?