Yes, I have just had a conversation with someone about the challenges I have been having with SSAS and they pointed out the same thing "SSAS will handle snowflake fine but it sounds like you data warehouse is not a very good design".