Thank you Phil

The duplicate in the Code table an error on my part - I manufactured this sample carelessly! Your solution is gracefully simple, my actual data is of course...

... P.S. as there can be many Standards, I'm hoping not to Hard-Code WHERE clause on that column.

Maybe, but not for for a while yet. The data sample used to illustrate this article is extremely simple, compared to that which most data migration specialists come into contact...

Nice work!
But what I'd really like to know: How do compilers know when they've provided sufficient numbers in the cells, for it to be possible to complete the...

Thanks Dave,

Whilst plucking up courage to try your solution, I found that by right-clicking in the Solution Explorer I got another option to change the Impersonation Mode. When I selected...

...And I should have said, this is all on the local machine.

RW

I'm still struggling with this, despite trying all the options;

In the Server Explorer, the connection uses Windows Authentication.

In the Analysis Services Project database tab, Properties, I have tried:

1) Use the...