Relationship with optional in-between table
I think that the idea of a special &ldquo;empty&rdquo; subdimension that is used if there is no real subdimension is the best one. It makes the data model and the queries simple.