Chasm Trap
A chasm Trap is a many - one relationship.
This would happen when two "many to one" joins converge on a single table. You will get incorrect results when the following circumstances exist:
A "many to one to many relationship" exists among three tables in the universe structure. The query includes objects based on two tables both at the "many" end of their respective joins. There are multiple rows returned for a single dimension.
One way to resolve a Chasm Trap use Designer to define a context for each table at the "many" end of the joins. This creates two SQL statements and two separate tables in Business Objects.
Another way to resolve a Chasm Trap is in Designer select the option Multiple SQL Statements for Each Measure from the Universe Parameters dialog box. (This is a default setting). Only applies to measures. You force the SQL generation engine in Reporter to generate SQL queries for each measure that appears in the Query panel. You cannot use this solution to generate multiple SQL statements for dimensions.
A chasm Trap is a many - one relationship.
This would happen when two "many to one" joins converge on a single table. You will get incorrect results when the following circumstances exist:
A "many to one to many relationship" exists among three tables in the universe structure. The query includes objects based on two tables both at the "many" end of their respective joins. There are multiple rows returned for a single dimension.
One way to resolve a Chasm Trap use Designer to define a context for each table at the "many" end of the joins. This creates two SQL statements and two separate tables in Business Objects.
Another way to resolve a Chasm Trap is in Designer select the option Multiple SQL Statements for Each Measure from the Universe Parameters dialog box. (This is a default setting). Only applies to measures. You force the SQL generation engine in Reporter to generate SQL queries for each measure that appears in the Query panel. You cannot use this solution to generate multiple SQL statements for dimensions.
No comments:
Post a Comment