SQLServerCentral / Data Warehousing / Analysis Services / Count function issue in MDX in SQL Server 2008 R2 / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 01:47:51 GMT20Count function issue in MDX in SQL Server 2008 R2http://www.sqlservercentral.com/Forums/Topic1063294-17-1.aspxBelow query is running well in SQL server 2005:"COUNT(filter(periodstodate([Fiscal Date].[Fiscal].[Year],[Fiscal Date].[Fiscal].[Month].&[201012]),[MEASURES].[Rating NEW] >0))"But this query in causing increment in page file usage in the analysis services of SQL server 2008 R2.Error msg: 'The Operation has been Cancelled due to memory pressure.'This issue is coming when 'Count', 'filter' & 'periodstodate' conditions are used together. Individually these functions are working fine in the measure.Please suggest any alternate approach to implement the above mentioned MDX.Sun, 13 Feb 2011 23:14:04 GMTMitra_Misra