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/