Hi JohnC5244, We can achieve the performance optimization at both SSRS and SSAS level, at SSRS level, you could have a check to the values in columns TimeDataRetrieval, TimeProcessing, and TimeRendering from ExecutionLog2table in the ReportServer database when the report is executed. In this way, we could get to know the performance of each step. Then take relevant measures given in this link http://msdn.microsoft.com/en-us/library/bb522806.aspx At SSAS level, I would recommend you refer to Analysis Services Performance Guide whitepaper, this white paper describes how application can apply query and processing performance-tuning techniques to their SQL Server Analysis Services OLAP solutions, which is available at this link http://www.microsoft.com/download/en/details.aspx?id=17303 Hope this helps. Regards, Charlie Liao

I have a SSRS report that using a SSAS cube as its datasource. Within the cube I have a semi-additive measure using the LastNonEmpty aggregation type. In order to display the proper measure value within the report I use the aggregate function with reporting services. When I preview the report in designer it takes forever to render. Has anyone else had this same problem when using the aggregate function?