Please look into below MDX query it is resulting in system.outofmemoryexception when i try to run in MDX query analyzer Details MRCODE has 1797 rows DIV has 6 rows STKCD has 4434 rows Product Name has 507 rows when crossjoin this .....it is giving problems.. Please let me know in case any modifications on it i cannot try NONEMPTYCROSSJOIN on it SELECT ALL ( Hierarchize( CrossJoin([Dim SM].[MRCODE].[MRCODE].members, CrossJoin([Dim SM].[DIV].[DIV].members, CrossJoin( [Dim SM].[STKCD].[STKCD].members, [D Im Prod].[Product Name].members ))))) ON ROWS,[Measures].[QTYCHRG]ON COLUMNS from [ABCDW2] thanks in advance