Count function issue in MDX in SQL Server 2008 R2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Count function issue in MDX in SQL Server...

Count function issue in MDX in SQL Server 2008 R2

Rate Topic

Display Mode

Topic Options

Author

Message

Mitra_Misra

Posted Sunday, February 13, 2011 11:14 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 11:04 PM
Points: 18, Visits: 102

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.

Post #1063294

« Prev Topic | Next Topic »

Permissions