MDX crossjoin is not responding...it is giving system.outofmemoryexception on below query excution
Database
1
Posts
1
Posters
0
Views
1
Watching
-
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