範例:資料匯入檔案 - 匯率

若是多重幣別應用程式,則需將匯率匯入「匯率」立方體。

資料匯入檔案可以有這些列。第一列是必要的檔案「欄標頭」:

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