Semantic Layer - Join Path (or Query Path)

Star Schema

About

In a semantic layer, a join path is a series of joins that a semantic query can use to access data in the tables linked by the joins.

Join Path problems

Join Path problems can arise from the limited way that lookup and fact tables are related in a relational database. The three major join path problems that you encounter when designing a model are the following:

Most join path problems can be solved by creating an alias




Discover More
Bobj Chasm Trap
BOBJ - Chasm Traps (converging many to one joins)

Chasm Traps is see as a Join Path problem or data modeling issue (convergence type ) which returns more data than expected by returning a cartesian product. A chasm trap is a type of join path...
Bobj Context Structure Pane
BOBJ - Context

Contexts are a collection of joins which provide a valid query path for to generate SQL. You use contexts to resolve join problems that can return too many or too few rows because of the way that...
Bobj Fan Trap Good Result
BOBJ - Fan Trap (serial many to one joins)

The fan trap in a BOBJ context. A fan trap is a join path problem returning too many rows. The original query which returned the Cartesian product for Wendy Craig, must return the following table...
Card Puncher Data Processing
BOBJ - Joins (Home)

The Joins in BOBJ. You have several approaches to creating joins in : Tracing joins manually in the schema (Drag and drop) Defining join properties directly ( Menu Select Insert > Join ) ....
Bobj Loop Structure Pane
Semantic Layer Modeling - Loop issue

Loop is a join path problem which is a set of joins that defines a closed path through a set of tables If you model based on the above structure, any query run against the tables in the loop would...



Share this page:
Follow us:
Task Runner