Answer Posted / 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 |
Post New Answer View All Answers
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
How we drill up week to month?
What is a bo repository?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
what are the tables used in health care domain project and columns used in report?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Explain is there any other repository domains rather than universe, security, document?
what is document design in boxi,have u participate in that
what are the day to day activities of BO administrator ?
Explain about a time when you discovered a more efficient way to do a work task?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye