A classic, albeit a bit dated, book is Fast Track to MDX. It’s a great overview and a quick read, though it doesn’t cover the new MDX features of SQL Server 2005. The Spofford book MDX Solutions is more up date and a little deeper, but a bit harder to get through. I also highly … Read more
This is usually a result of having both blanks and NULLs in the source table/view. Essentially, SSAS does this for every attribute SELECT DISTINCT COALESCE(attr,”) FROM SOURCE Analysis services by default converts NULLs to blanks, resulting in duplicate value blanks in the resulting feed – hence the error. I agree this sucks and is a … Read more