"I am looking to connect the TestDetails dimensions to the test measure".

Then you either need to combine the tables as I indicated so that you have one fact table. All dimensions can then be assigned to this fact table. You can then roll up from the test details to analyse by all dimensions which I think is what you require.

However, as I have also described as they are different grains this may not be feasible and you would need to be careful of the dimensionality of the primary table. In this case you can have separate fact tables but you would need to add the dimension information related to the test details to the test measure.

Do this in the DW if this exists. If not this should be possible by using the abstraction layer of the dsv and using a named query.