LookML "Outer Join On False" (OJOF) Skill

1. Overview

Problem

When querying multiple independent fact tables with different grains (e.g. Sales Orders, Line-Item Fulfillment, Inventory, Web Events) in a standard Looker explore, joins cause cartesian fanouts, chasm traps, or require heavy symmetric aggregate calculations.

Solution

The OJOF Pattern solves this by treating fact tables as parallel peers connected to a 0-row dummy table, dynamically binding shared dimensions and co-dimensions via Liquid.