I have the following data in an sql server table:

Name Effective Expiry Amount
Test1 18-Aug-03 19-Sep-03 500
Test1 15-Sep-03 19-Jan-04 200
Test3 01-Jan-03 31-Dec-03 900
Test4 29-May-03 29-Oct-03 600


I need to produce the following report:

Name Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03 Jan-04
Test1 203.125 320.6845 49.20635 47.61905 49.20635 30.15873
Test3 76.64835165 69.23077 76.64835 74.17582 76.64835 74.17582 76.64835 74.17582 76.64835 74.17582 76.64835 74.17582
Test4 7.843137 117.6471 121.5686 121.5686 117.6471 113.7255


As can be seen from the above the information that needs to be produced is the amount on money that is earned each month. The users may also want to see the information by quarter or by year i.e the amount earned each quarter or year. Is this possible to do with analysis services? If so how would I go about doing it?

Thank you

I have the following data in an sql server table:

Name Effective Expiry Amount
Test1 18-Aug-03 19-Sep-03 500
Test1 15-Sep-03 19-Jan-04 200
Test3 01-Jan-03 31-Dec-03 900
Test4 29-May-03 29-Oct-03 600

I need to produce the following report:

Name Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03
Nov-03 Dec-03 Jan-04
Test1 0 0 0 0 0 0 0 203.125 320.6845 49.20635 47.61905 49.20635 30.15873
Test3 76.64835165 69.23077 76.64835 74.17582 76.64835 74.17582 76.64835
74.17582 76.64835 74.17582 76.64835 74.17582
Test4 0 0 0 0 7.843137 117.6471 121.5686 121.5686 117.6471 113.7255

As can be seen from the above the information that needs to be produced is
the amount on money that is earned each month. The users may also want to
see the information by quarter or by year i.e the amount earned each quarter
or year. Is this possible to do with analysis services? If so how would I go
about doing it?

Thank you