Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

5041


what is xcelsius architecture?

4545


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2197


What is package in BO

3172


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2404


Difference between b.o 5.1 and 6.1b?

1192


Explain what are the measure objects?

958


Explain how to schedule the report in b.o?

1007


Explain what task is 98% of the required work of a business analyst?

1045


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2119


What is a bo repository?

1012


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1231


When to use local filter and when to use global filter?

961


What is the difference between condition & filter?

1417


how to create reports on screech?

2513