The target cube contains the Account, Category and Time dimensions.
The target data is aggregated prior to the copy process.
If the source dimension member (the member record in the data file) already exists in the application set, the source dimension member overwrites the member that exists in the application set.
Note
ID is the only key that can be used to determine whether or not the member already exists.
If the source dimension member does not exist in the application set, the source dimension member is inserted into the application set as a new member.
The dimension members in the application set (but not in the source file) do not change.
Example Format
In this example, the dimension is Account and the first date column is ID.
Source Data
10000000,AST,,Current Assets,,
11000000,,,ENDFLOW,,,,,,F_900,,ST,,,,,,,,,,,
11110000,AST,,Petty Cash,,
11112001,,,ENDFLOW,,,,,,F_900,,ST,,,,,,,,,,,
Pre-Import Application Set Account Members
11110000,ASTAA,,Cash1,,
11112001,,,ENDFLOW,,,,,,F_900,,ST,,,,,,,,,,,
Post-Import Application Set Account Members
10000000,AST,,Current Assets,,
11000000,,,ENDFLOW,,,,,,F_900,,ST,,,,,,,,,,,
11110000,AST,,Petty Cash,,
11112001,,,ENDFLOW,,,,,,F_900,,ST,,,,,,,,,,,