How do you find what type of trap is there by seeing the
report?
- 4 Answers
- 5994 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sj
We can find out Chasm trap and Fan trap by just viewing the
table schema.
If we have many to one to many relationship between three
tables that is a chasm trap.
If we have one to many,one to many relationship between
three tables that wil be a fan trap.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / tarukhemu
Consider you have one dimension linked to two fact tables. One fact contains branch wise revenue and another fact contains branch wise sales. For example:
Fact 1: Branch Revenue
101 1000
201 2000
201 1500
Fact 2: Branch Sales
101 5
201 10
Now if you want to display Branch,Revenue as well as sales,then the data in report will appear as follows:
Branch Revenue Sales
101 1000 5
201 2000 10
201 1500 10
As per Fact 2,Branch 201 has Sales=10,but in report it displays Sales as 10+10=20,which is wrong.
Hence by looking at the report data,you can identify a trap.
Note: This is a case of Chasm Trap
| Is This Answer Correct ? | 2 Yes | 1 No |
by viewing we can define weather it is fan trap or chasm trap
Fan trap: When three tables were joined in one to many relationship then it is fan trap.
Chasm trap: when two fact tables depend upon the same lookup table then it is known as chasm trap.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pradiip
As per my understanding we can find the traps only by the cardinalities of the present tables and the other best way is 'Detect Context' because if there is more then one way/Context to achieve the results definitely there is a trap. it may be Chasm or Fan.
| Is This Answer Correct ? | 0 Yes | 0 No |
Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?
What is Complex Reports?
Have you worked with multiple data sources? If yes. How do you link them?
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
what is universe testing(not mention check integrity)
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
what is fantrap ?
What are alertors in Business Objects?
how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?
difference between web intelligence,crystal reports and desktop intelligents
Can any one gve me the complete information abt Certfication of Business Objects ?
HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..
Teradata 
