I have selected Month 2 1997 in the Budgets cube and I want to display
the budgets for the next 4 months using MDX.

Please advice how having selected a current month I can have the system
show the rolling budgets for the next 4 months in MDX.

I am looking at producing the outputs something like this:


Assuming February 1997 is chosen I want the layout to look like this:

================================================== ============
Stores February March April May Total
================================================== ============
...... ... ..... ... .......


================================================== ============


So I want the system to show the rolling next 4 months budgets and the
totals as well as the captions for the months like February.

Please kindly help with the MDX I have to present some proof of concept
reports to the users on Analysis Services can do this kind of
reporting.

Your help is greatly appreciated.

Thanks
Karen