• Ok,

    So the answer was that I hadn't created the Named Calculations in the DSV. Once I created the 'real' measures I needed then my original SCOPE statement worked a treat. Looks like I just hadn't read the instructions!!!

    It was thanks to Chris Webb's blog found here[/url] that helped resolve the issue.

    Cheers,

    Jim.

    SQL SERVER Central Forum Etiquette[/url]