How to reload data that has been exported in Data Management
Content
Basically, I need to change the sign of data on some accounts that need to be changed from Expense to Revenue.
I have exported the relevant data from FCCS to a flat file via Data Management in the following format:
Entity,Account,BusinessArea,Intercompany,Movement,Product,View,Year,Period,Data Source,Amount
My problem is now how to reload this data in Data Management.
The issue is that Both Year, Period and Data Source is included in the data file and needs to be mapped.
In the existing FCCS Target Application there is no UDx defined for the Year, Period and the Data Source is defined in Application Options and is set to FCCS_Managed Data hence those 3 dimensions do not show up in Dimensions in Data Load Mapping.
Tagged:
0