Some links about the good old (and dead?) SSAS Multidimensional Cube

Why doesn’t SSAS cache the entire cube?
Also, if you cube is much larger than the memory available to SSAS, then you would expect to see continual IO, and it is likely to be quite well optimised. However, when you have a 64 bit server with a cube that is larger than 3GB but is comfortably less than the server memory, you might be surprised to see the volume of continual IO.

http://richardlees.blogspot.com/2011/12/why-doesnt-ssas-cache-entire-cube.html

Best Practices for Performance Tuning in SSAS Cubes, you are in right place. Define cascading attribute relationships, for example, day > Month > Quarter > year  and define user hierarchies of related attributes (called natural hierarchies) within each dimension as Appropriate for your data

Best Practices for Performance Tuning in SSAS Cubes, you are in right place. Define cascading attribute relationships, for example, day > Month > Quarter > year  and define user hierarchies of related attributes (called natural hierarchies) within each dimension as Appropriate for your data

Remove redundant relationships between attributes to assist the query execution engine in generating the appropriate query plan. Attributes need to have either a direct or an indirect relationship to key attributes, not both.


https://mindmajix.com/msbi/best-practices-for-performance-tuning-in-ssas-cube

https://kejserbi.wordpress.com/

https://hub.packtpub.com/query-performance-tuning-microsoft-analysis-services-part-1/

https://github.com/RichieBzzzt/SSASActivityMonitor

https://github.com/ssasdiag/SSASDiag

https://christianb7.wordpress.com/2012/11/11/analysis-services-2012-configuration-settings/

https://www.mssqltips.com/sqlservertip/2568/ssas-best-practices-and-performance-optimization-part-4-of-4/