Skip to Content
0
Former Member
May 19, 2010 at 10:28 AM

Spliting records into cube

22 Views

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