Find id's of a dimension referenced from a fact table via multiple attributes.

find_ids_of_demension_mult_attributes.sql

SELECT dim.id FROM dim WHERE dim.id NOT IN 
    (
        SELECT DISTINCT fact.dim_one_id FROM fact
    )
AND dim.id NOT IN
    (
        SELECT DISTINCT fact.dim_two_id FROM fact
    )
AND dim.id NOT IN
    (
        SELECT DISTINCT fact.dim_three_id FROM fact
    );