How Do You Resolve a Fan Trap?

There are two ways to solve a fan trap problem.

·            Create an alias for the table containing the initial aggregation, then use Detect Contexts (Tools > Detect Contexts) to detect and propose a context for the alias table and a context for the original table. This is the most effective way to solve the fan trap problem.

·            Altering the SQL parameters for the universe. This only works for measure objects.

Both of these methods are described below.