i am trying to create a report in excel using SSAS cube as a source. when i use more than 4 dimension attributes the performance is very poor . Also i am placing attributes from one dimension side by side.
when i create a trace using sql profiler i see that MDX generated is having cross joins . how can i get rid of these cross joins or is there any alternative for this. please help.
Thanks for your reply. Not all MDX queries generated by Excel are slow only some of them are. Number of rows generated by this particular MDX are 122244. Is there any way that we cam modify in Excel.The MDX is below.Thanks for your response again.
SELECT NON EMPTY CrossJoin(CrossJoin(CrossJ