Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Count function issue in MDX in SQL Server 2008 R2 Expand / Collapse
Author
Message
Posted Sunday, February 13, 2011 11:14 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 30, 2013 1:56 PM
Points: 18, Visits: 103
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 »

Add to briefcase

Permissions Expand / Collapse