You have to tinker with the cube database properties until you get the correct settings for your circumstances and data. What I have found is that as the cube grows...

Using MDX with Custom Calendars is tricky - basically you have to avoid using MDX fuctions and simply write the code to lag back by the number of days or...

You can try Novaview Panorama

I wouldn't use MDX to extract tens of millions of rows. Analysis Services performs better with data sliced and aggregated to more manageable levels. Your data warehouse should be summarizing/aggregating/grouping...