Dear Gurus,
I have my planning template which is planning is done month wise
i.e
Month Amount
-
-
January USD 60000.00
I need to store this data in my cube by dividing it to day wise data
i.e
CalDay Amount
-
-
01/01/2010 USD1935.48 (USD60000/31days)
02/01/2010 USD1935.48 (USD60000/31days)
03/01/2010 USD1935.48 (USD60000/31days)
....
....
.
.
.
Can anyone suggest how do i do this
If it is in the transformation, can anyone point out the coding fro me
Thank you
BR