Answer Posted / krish
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 |
Post New Answer View All Answers
How to execute the plsql procedure from the report by clicking with mouse?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
what will be the contents for a functional requirements specifications
What is difference between custom hierarchy and report based hierarchy?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
How we drill up week to month?
What is package in BO
Explain when to use local filter and when to use global filter?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
what is xcelsius architecture?
How were the reports scheduled and how to resolve unexecuted documents?
What is the difference between business requirement document and use case document.
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
