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