Show TOC

Example documentationImport Transaction from a Data File Example Locate this document in the navigation structure

 

Prerequisites

The target cube contains the Account, Category, and Time dimensions.

The target data is aggregated prior to the copy process.

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 Note

All dimension members in the record are treated as a composed key.

End of the note.

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

Result

Post-Import Cube Records

ACTUAL,CASH,2006.MAY,500

ACTUAL,CASH,2006.JULY,300

ACTUAL,CASH,2006,JAN,700