Wish I could give you the silver bullet, but in the absence of someone who can, I'll keep doing my best! Do you have this problem with any other cube,...

As soon as I see "security IDs" I start to think of SIDs. These are unique identifiers that sql server assigns to usernames. I've never run into issues with SIDs...

Theo: describe your problem and we'll see if we can help.

Cheers,

ziangij, I would definitely recommend reading through some of the comments, but here's my summary:

If you have other logic to prevent/handle collisions, checksum might be fine. If you want to...

I'm now seeing this error on a SQL Server 2008 R2 machine. Anyone ever find a fix for it? I'm going to try reprocessing the cube and see if that...

Are you processing it from within BIDS, or from SSMS? The settings seem much more straight-forward from in SSMS (Management Studio) so maybe try that.

My $.02: I usually find when I get that error it's because I have NULL values. I make myself crazy trying to find problems with the data, when it's actually...

Maybe I"m interpreting this incorrectly, since it's entirely different from everyone else's, but I think what you're looking for is the total of the Parent (perhaps ALL) member for the...

I would start by searching the text of your .cube files (right click -> view code) for the text "0 0". It shouldn't be common enough for it to be...

Did you look at this: http://support.microsoft.com/kb/956377

?

Cheers,

I think there's a significant element missing from the "which way is faster to process" debate (hash then compare, or just compare): time to market. As in, how quickly can...

OK, I'm starting to understand what you're trying to do. Sure, use the SP as an OLE DB Source (read this: http://consultingblogs.emc.com/jamiethomson/archive/2006/12/20/SSIS_3A00_-Using-stored-procedures-inside-an-OLE-DB-Source-component.aspx), then multicast. Just to suggest an...

I'm not really clear on what you're attempting to do. Do you want to use the SP to denormalize the data because you don't want to reproduce the logic, which...

Maybe it's the main thing I hate about the new versions of Windows: you have to run the app as administrator? No idea on that, but it's pretty easy to...

I found that after I got over the initial UI shock (which I like, btw), many of the functions are the same in Windows 7 as XP, etc:

Windows Explorer ->...