Administering Financial Consolidation and Close

Example: Data Import File - Exchange Rates

For multiple-currency applications, you import rates to the Rates cube.

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

Period, Average Rate, Ending Rate, Point-of-View, Data Load Cube Name

Jan, 1,1,"USD, FCCS_Global Assumptions, From_USD, Actual, FY16, FCCS_Periodic", Rates

Feb, 1,1,"USD, FCCS_Global Assumptions, From_USD, Actual, FY16, FCCS_Periodic", Rates

Mar, 1,1,"USD, FCCS_Global Assumptions, From_USD, Actual, FY16, FCCS_Periodic", Rates

Jan, 2,2,"USD, FCCS_Global Assumptions, From_CAD, Actual, FY16, FCCS_Periodic", Rates

Feb, 2,2,"USD, FCCS_Global Assumptions, From_CAD, Actual, FY16, FCCS_Periodic", Rates

Mar, 2,2,"USD, FCCS_Global Assumptions, From_CAD, Actual, FY16, FCCS_Periodic", Rates

Jan, 3,3,"USD, FCCS_Global Assumptions, From_AUD, Actual, FY16, FCCS_Periodic", Rates

Feb, 3,3,"USD, FCCS_Global Assumptions, From_AUD, Actual, FY16, FCCS_Periodic", Rates

Mar, 3,3,"USD, FCCS_Global Assumptions, From_AUD, Actual, FY16, FCCS_Periodic", Rates