Case 2
Accumulating data loader records: Data Loader allows you to accumulate (sum) data of the same subcube. When YTD_DATA is used with In_Batch_Accumulation/Accumulation option, the Data Loader sums all the individual YTD data records in the file before calculating the periodic value.
This example assumes that January is the first period of the year. The data file contains April, May and June YTD data, while the database table (ICRepPer_Base) contains January, February and March data.
| Database | January | February | March |
|---|---|---|---|
| ICRepPer_Base | 10 | 11 | 12 |
| April | May | June | |
|---|---|---|---|
| YTD Data Loader Row 1 | 20 | 25 | 34 |
| YTD Data Loader Row 2 | 26 | 35 | 41 |
| ICRepPer_Base (P) | 13 | 14 | 15 |
| ICRepPer_Base (B) | 46 | 60 | 75 |
- April periodic = (20+26)-10-11-12=13
- May periodic = (35+25)-10-11-12-13=14
- June periodic = (41+34)- 10-11-12-13-14=15