• You are going to need an adequate amount of RAM and CPUs to run the reporting on this machine.

    Read about Max Server Memory for you instance of data, then about memery settings for SSAS and SSRS so not to use Page Filing when memory runs out.

    Here is a good start to a conversation about this topic on a forumn: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/40e7737a-4f20-41d3-8f95-ad5e9ee21986/confused-about-ssas-memory-usage?forum=sqlanalysisservices

    Thomas

    Thomas LeBlanc, MVP Data Platform Consultant