I have a inventory cube which as a measure - STOCKONHAND and the
dimensions -

PRODUCT
CALMONTH

Where the cube stores the dimension PRODUCT and CALMONTH with the
measures - STOCKONHAND.


Now I wish to report as follows: Product on Rows and STOCKONHAND AND
CALMONTH on columns as follows:


Product StockOnHand
======================
1 2 3 4 5
ABC001 120 150 135 145 225
XYZ008 980 450 230 128 290


Can somebody please share ideas how I can implement this report. Also
when the user refreshes this report I want to be able to generate a
popup that asks for the tomonth and generates the months like
1,2,3...tomonth.

Please clarify how I can do this.

Thanks
Karen