When performing load from data stream task, the settings for the task is "Input Type = Cumulative" and "Update Mode = Delete All".
The data in the source cube is cumulative figures. When the task is performed, the system is reading data for all the period in the source cube, calculating the difference and posting the difference to the selected period in BCS. For example, if i have selected period 02 as selection parameter in UCMON, the system reads 00, 01 and 02 from the source and populates the difference to 02 in target instead of just reading the 02 period data from source.
I am expecting the system to read the data from source based on parameter selection (posting peiord =2) and post the difference to target so that in BCS the total is equal to cumulative figure in source for period 02.
Posting Period Jan Feb
Data in Source 100 250
Data in Target is
Jan 100 100
Feb 0 250
Data in Target should be
Jan 100 100
Feb 0 150
System reads value 350 (100+250) from source, and posts 250 (350-100) to feb period.
How can I ensure that system reads only 250 from source for period 02, and posts 150 in BCS for 02 period.
Appreciate your response and help on this matter.