Count function issue in MDX in SQL Server 2008 R2

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

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply