Semantic Layer Modeling - Issues (SQL Trap)

When modeling a semantic layer, you can encounter issues that impact the results obtained from semantic queries.

You may need to resolve join problems such as :

• loops,
• missing data traps,
• chasm traps,
• and fan traps,

which may be resolve in the structure by using:

• aliases
• and/or contexts. <note tip>A subject area in OBIEE is the context</note>

• Relational model - Modelling issues