BusinessObjects Topics

Search This Blog

BusinessObjects Topics

Thursday, May 22, 2008

What is a Chasm Trap

What is a Chasm Trap

Simply put: A chasm occurs when a series of joins crosses a many >- one -<>

A >- B -<>

If I were to write a query that spanned all three of those tables the data from table A and C would be duplicated and measure values would be inflated. The inflation factor can be determined by counting the number of rows from the left that match a particular key and multiplying by the number of rows on the right....... for more details

0 comments:

Tags

Oracle Data warehouse Business Objects Business Objects XI R2 Business Objects XI 3 PLSQL BOBJ BI News Business Objects FAQs bo DataModeling Concepts Databases Server Administration BOCP-BOE Business Intelligence (BI) MS SQL Sever Database Universe Designer Certification Designer REPOSITORY SAP BI SAP Education Supervisor BO Reporter/ functions BO XI 4.0 BOXI 3.1 Business Objects Designer Downloads Fan / Chasm Trap Functions Integration and Certification Loops MS SQL Sever Administration OLAP QaaWS SAP Business Objects SAP BusinessObjects Business Intelligence 4.0 Star Schema Universe Design Web Intelligence WebIntelligence