Example: Data Import File - YTD View

Data can be loaded to Financial Consolidation and Close on a Year-to-date (YTD) basis. If data is loaded to the FCCS_YTD_Input View dimension member instead of the FCCS_Periodic member, then Financial Consolidation and Close will populate the periodic member such that the YTD amount matches the input amount. In all periods except the first period, the prior period YTD amount is subtracted from the YTD Input amount and the result is written to the Periodic View. In the first period, the YTD Input amount is written to the Periodic View. The YTD Input amount is then cleared. Note that this population of the periodic amount is based on a YTD input amount and NOT a Closing Balance input amount (although for Income Statement accounts only, these are the same).

When you load data in YTD_Input, if the current period value is the same as the prior period value, the system does not store a zero (0) Periodic value, which helps to improve the performance of the data load.

Closing Balance includes the impact of Opening Balance while YTD excludes Opening Balance and encompasses movements for the current year only, excluding Opening Balance. For Closing Balance Input, see the section on the Closing Balance Input Hierarchy in Seeded Dimension Members.

Also, note that if you load data on a Quarterly basis in the YTD View, if there are periods with NoData status between the current period and a period where data was entered, the in-between periods with NoData calc status are changed to Impacted at the start of the consolidation process and changed to OK on completion. All of the ancestor's status are changed to Impacted for those periods if their status was NoData prior to consolidation.

Suppose the following data exists in the application for the Sales account:

Sales...Jan: 100, Feb: 250, Mar: 370

A data import file would have these rows. The first row is the required file Column Headers:

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

Jan, 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, 250, "FCCS_Entity Input, ENTITY CURRENCY, England, FCCS_Data Input, FCCS_No Intercompany, FCCS_No Movement, Actual, FY14, FCCS_YTD Input, FCCS_Local GAAP", Consol

Mar, 370, "FCCS_Entity Input, ENTITY CURRENCY, England, FCCS_Data Input, FCCS_No Intercompany, FCCS_No Movement, Actual, FY14, FCCS_YTD Input, FCCS_Local GAAP", Consol