Interested to Buy Any Domain ? << Click Here >> for more details...
How do you find what type of trap is there by seeing the
report?
- 4 Answers
- 7515 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 |
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )
1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?
how did u give developed universe to ur client?
who r the users in B.O.XIR2?
Did you face any problems while creating reports? Name? Solutions?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
what do u mean by variable functions ?
my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it
how to creat 2 way drilling mode.can any one know this
1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.
Teradata 
