Can some one explain in detail about the following:
What are Traps?
How to recognize the Traps?
How to solve them?
Answer Posted / thotadwh
The are the causes for incorrect results in your reports.
There are two types of traps occurs in the universe, namely
chasm and fan traps.
chasm trap- it occurs when two many to one joins directs
from two fact tables and one end of the joins converges at
the same dimension table.
Because of this you will get inflatted results.
You user contexts to separate both the join paths to resolve
chasm traps.
Fan trap- it occurs when two one to many joins associates
with three tables in a series.
also effect the results same as chasm trap
you solve fan traps using aliases in general
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the difference between absolute and relative div positioning?
Can more than 1 metric be applied on an analytic in business objects?
Difference between zabo and webi?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain the difference between union and group?
How to create Index to the table in the universe designer and how it improves the Query performence
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain difference between zabo and webi?
Did you face any problems while creating reports? Name? Solutions?
Explain what are the measure objects?
How would you format some text using css to be verdana and bold?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?