I am trying to load Budgets data into a cube via DSO.
The problem here is i have budgets data aggregated at FISCALWEEK level. but i need to split this data into 7 equal days and update 7 recrods in cube. Total amount should be divided by 7.
Data in DSO is
WEEK | Cost | *30.2009 | 10000|* 29.2009 | 12000|
Now i need to split these budgets into Day level and load to the cube.
CALDAY | WEEK | Cost | 20.04.2009|30.2009|1428.57 21.04.2009|30.2009|1428.57 22.04.2009|30.2009|1428.57 23.04.2009|30.2009|1428.57 24.04.2009|30.2009|1428.57 25.04.2009|30.2009|1428.57 26.04.2009|30.2009|1428.57
Any help would be appreciated.