79564811

Date: 2025-04-09 16:10:08
Score: 2.5
Natty:
Report link

A fan trap only needs 2 tables in a 1:m relationship. The parent record gets duplicated over the child records causing aggregations over metrics found in the parent record to be in error. Fortunately, if you define the association in some of the modern BI tools (instead of SQL JOINs) you will get correct results. This is true of Power BI, Tableau & QlikView.

Reasons:
  • No code block (0.5):
  • Unregistered user (0.5):
  • Single line (0.5):
  • Low reputation (1):
Posted by: Steve Wright