Interested to Buy Any Domain ? << Click Here >> for more details...
what is fantrap and chasmtrap ?
- 5 Answers
- 16244 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / santhosh
Fantrap means one-to-many joins of the tables it is
detected by visval analysis. By using fantrap problem is
many rows than expected. Through aliases,context and check
mutiple sql statements for each measures option we can
solve this problem.
chasm trap means two or more many to one joins converge on
to a single lookup table
| Is This Answer Correct ? | 11 Yes | 0 No |
Chasam Trap:
chasm trap means many-to-one and one-to-many join relation
converge on to a single lookup table, because of this we
get incorrect results i.e., cartision product, We will
resolved by using some times alias, some times context,
some times shortcut join and check mutiple context for each
measures option.
Fan Trap:
Fantrap means one-to-many and one-to-many join relation of
the tables it is detected by visval analysis, because of
this we get incorrect results i.e., cartision product,
We will resolved by using some times alias, some times
shortcut join and check mutiple sql statements for each
measures option.
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / shiva
these two are the loop problems
fantrap-fanning out of one to many leads to one to many
relation ships
chasamtrap-converging two fact tables into single lookup
table
fantrap can be solved by alias
chasamtrap can be solved by context
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / nmr
fantarp is nothing but 2 one to many realation turned as 1
one to many realation.
the report doesn't get exact results ,
we can solve it useing contexts,
chasm trap 2 many to one realtionship tuned in to one
doesn't fetch exact results
we can solve the problem useing alias or context
based on require ment.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nmr
fantarp is nothing but 2 one to many realation turned as 1
one to many realation.
the report doesn't get exact results ,
we can solve it useing contexts,
chasm trap 2 many to one realtionship tuned in to one
doesn't fetch exact results
we can solve the problem useing alias or context
based on require ment.
| Is This Answer Correct ? | 0 Yes | 1 No |
what is a Micro cube?
Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.
i want to take a report 10 records per page. How to take it? is there any paging option in BO?
What is mean by tuning the report?
I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
What are the steps to be taken to schedule the report?
why measure objects are semantically dynamic?
How to create universe in business objects enterprise 11.5
Difference between Decode and Case?
8 Answers Polaris, TCS, Wipro,
Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?
What are the steps to taken care to improve the Report performance?
Teradata 
