Intermittently Getting below mentioned error during processing OLE DB error: OLE DB or ODBC error. Transaction (Process ID n) was deadlocked on thread| communication buffer resources with another process and has been chosen as the deadlock victim.
Cause: A deadlock is a circular blocking chain, where two or more spids are each blocked by the other so that no one can proceed.
You don’t have control over the Select Statement generated by SSAS Processing job (If you are not using Named Query in DSV), in that case you need take care of things from SQL Engine Perspective.
Here are few recommendations, which can reduce deadlock situation:
SET TRANSACTION ISOLATION LEVEL (Transact-SQL)
How To Monitor Deadlocks in SQL Server