Below 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.