Home

Outer Join Control in Mosaic Models and Mosaic Schema

Share:

Design richer, more complete analytics in Mosaic with new support for outer join relationships across Mosaic Models and Mosaic Schema (formerly known as Project Schema). Modelers can now define attribute-level join behavior, selecting from keeping only matched records, preserving all lookup values, preserving all fact/relationship rows, or retaining records from all tables. This makes it easy to show customers, stores, or borrowers even when no related facts exist, handle null-heavy data, and avoid missing rows. The result: no workarounds needed, more intuitive joins, and analysis that matches real business questions.

Read the full product documentation here.

MicroStrategy Video
Release Date: June 18, 2026