Product Costing Data Load
I am trying to load product cost data into BW using datasource 0CO_PC_PCP_03 into BW infocube 0COPC_C10
I am loading all 12 periods for last year 2014 (1 to 12) and 5 periods for 2015 (1 to 5) one by one.
When the data load was completed I checked the data in the cube and all the periods have exact same aggregated data. which doesnt make any sense to me.
In Period 1/2014, I have total cost/amount as $12500 and I have the same amount listed for all other periods which is Period 2 to onwards till Period 12/2014.
Not only this but when I checked 2015 data, it has the same amount i.e $12500 for each 5 period I loaded.
I am not sure what exactly is happening as due to the huge data and performance issue, I am loading data on period by period basis not all the data at once.
Can someone please advise if I need to have some special considering while loading product costing data as I have spend enough time to figure this out but cant resolve this.
Please see the attachment screenshot, I ran for a report for period 1, period 2 and period 5 for 2015 and the data is exactly the same, not even a cent difference
Will appreciate your help.