Thanks, all. These are really intriguing ideas but it sounds like there's no good way to do what I want. I think I'll have it periodically check a...

Maybe the Production cube hasn't been processed lately and is missing those 71 records?

I'm sorry but I don't understand the question. Could you give more information about what kind of data is in the Actual, Replace, and Cancelled fields? Some concrete...

Are you talking about Perspectives maybe?

In BIDS you manage security by adding Roles and then adding people to those Roles. It's a bit more complicated than that, obviously, but at least that would get...

If you can post some more information about what led up to that error then people may be able to help. Can you give step by step exactly what...