If you are into writing stored procedures for SSAS, then you owe it to yourself to checkout
Mosha's latest post on
Best Practices for ADOMD.NET stored procedures, it covers some really interesting stuff including things like preferring enumerators over iterators which can have a significant impact on performance.