Hi Richard,
Out of curiosity, when you say that for some main table entries there are no corresponding dimension entries, do you mean that corresponding rows simply do not exist? It's a mart requirement that dimension rows must always exist for every main row even if all the columns in the dimension row (apart from those in the foreign key to the main table) are null.
That was it! I wasn't inserting rows into the dimension tables if no data was available. Now I put in an empty row, and martview works as you would intuitively expect. Thanks for the tip!
Cheers, David.
