Show TOC

Example documentationImport Master Data 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 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 Note

ID is the only key that can be used to determine whether or not the member already exists.

End of the note.

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,,,,,,,,,,,

Result

Post-Import Application Set Account Members

10000000,AST,,Current Assets,,

11000000,,,ENDFLOW,,,,,,F_900,,ST,,,,,,,,,,,

11110000,AST,,Petty Cash,,

11112001,,,ENDFLOW,,,,,,F_900,,ST,,,,,,,,,,,