Example: Data Import File - YTD Input and Replace Mode

When you load data using the Replace mode, the combination of data for that Scenario, Year, Period, and Entity is cleared and replaced with the data in the load file.

When you load data to YTD_Input and use Replace mode for the load file, the system loads the data from the load file and reverses the YTD values from the previous period for the Flow accounts that are not specified in the data load file. This behavior will occur for all members under FCCS_Mvmts_Subtotal and FCCS_OpeningBalanceAdjustment in the Movement Dimension.

For the first period of a year, there is no YTD data to reverse, so the system applies this method for Periods 2-12 or 2-13.

This feature is supported for Administrator, Power User and User data loads. If a Power User or User performs the data load, the system will reverse the YTD values for which the user has Write access.

This example shows a data load file to the YTD_Input member in Replace mode. The first row is the required Column Headers:

Period, Sales, Point-of-View, Data Load, Cube Name

Feb, 100, "FCCS_Entity Input, ENTITY CURRENCY, England, FCCS_Data Input, FCCS_No Intercompany, FCCS_No Movement, Actual, FY14, FCCS_YTD_Input, FCCS_Local GAAP", Consol

Feb, 100, "FCCS_Entity Input, ENTITY CURRENCY, Ireland, FCCS_Data Input, FCCS_No Intercompany, FCCS_No Movement, Actual, FY14, FCCS_YTD_Input, FCCS_Local GAAP", Consol

Results:

The system reverses the YTD values for all the unspecified accounts (that is, all accounts except Sales that have a value in Prior Periods) in the data load file.