I've been using the Binary_Checksum to compare my source and target values before updating. This helps when you want to compare the two and handle NULL comparrisons at the same...

I just want to say thanks, I can use this to get rid of several while loops.

I found the issue, there was a filter being applied in my DSV that I had forgotten about. Removed the filter and cube processed with no problems.

I feel pretty dumb, I finally figured out why the cube would not process. The date dimension was being limited in the DSV. Moral of this, when all else fails...

Sorry, it's posted now

I came up with a strategy to manage dates in SSAS, and I almost have the kinks worked out. I added a second fact table that has the following columns:

DateId...

Very insightfull, will have to stew on it for a while. Thanks!

Be mindful of what the incremental update does during processing. You can load duplicates into your cube or partition if you are not careful. the incremental does not remove data...

I had the same problem, and after hours of debuggin. I just had my vendor send the file in .txt format and called it a day.