The target cube contains the Account, Category, and Time dimensions.
The target data is aggregated prior to the copy process.
If the record already exists in the data file in the cube, the record in the cube is overwritten by the corresponding record in the data file.
Note
All dimension members in the record are treated as a composed key.
If the record does not exist in the data file, it is inserted as a new record. If there are duplicate records in the data file of the other transaction, just the last transaction record is written into the cube. The records that exist in the cube (but not in the data file) are not affected.
Records in the Data File on First Transaction by User1
ACTUAL,CASH,2006.MAY,200
Records in the Data File on Last Transaction by User2
Records in the Data File
ACTUAL,CASH,2006.MAY,500
ACTUAL,CASH,2006.JULY,300
Pre-Import Cube Records
ACTUAL,CASH,2006.MAY,600
ACTUAL,CASH,2006,JAN,700
Post-Import Cube Records
ACTUAL,CASH,2006.MAY,500
ACTUAL,CASH,2006.JULY,300
ACTUAL,CASH,2006,JAN,700