匯入模式與累積類型範例

下列範例顯示匯入模式與累積類型選項如何運作。假設應用程式中存在下列資料:

Actual, FY15, Jan, California, Sales: 20,000
Actual, FY15, Jan, California, COGS: 10,000
Actual, FY15, Jan, California, Expenses: 5,000

匯入含有以下內容的載入檔案:

Entity, Sales, COGS, Point-of-View, Data Load Cube Name
California, 10000, 15000, ("Actual", "FY15","Jan"), Consol
California, 25000, 5000, ("Actual", "FY15","Jan"), Consol
California, #Missing, , ("Actual", "FY15","Jan"), Consol 

註:

此匯入將不會以 #MISSING 或空白值覆寫現有資料值。資料檔案中的最後一列將不會影響系統中的資料。

這些範例顯示使用下列選項組合匯入之後如何處理資料:

匯入模式:合併,累積類型:無

Actual, FY15, Jan, California, Sales: 25,000 (second record wins)
Actual, FY15, Jan, California, COGS: 5,000 (second record wins)
Actual, FY15, Jan, California, Expenses: 5,000

匯入模式:取代,累積類型:無

Actual, FY15, Jan, California, Sales: 25,000 
Actual, FY15, Jan, California, COGS: 5,000 
Actual, FY15, Jan, California, Expenses: #MI (Replace clears all data for all Scenario, Year, Period, Entity, Data Source combinations in the file before the import)

匯入模式:合併,累積類型:使用資料庫

Actual, FY15, Jan, California, Sales: 55,000 (Accumulate two records with existing value in database)
Actual, FY15, Jan, California, COGS: 30,000 
Actual, FY15, Jan, California, Expenses: 5,000

匯入模式:取代,累積類型:使用資料庫

Actual, FY15, Jan, California, Sales: 35,000
Actual, FY15, Jan, California, COGS: 20,000 
Actual, FY15, Jan, California, Expenses: #MI (Replace clears all data for all Scenario, Year, Period, Entity, Data Source combinations in the file before the import)

匯入模式:合併,累積類型:檔案內部

Actual, FY15, Jan, California, Sales: 35,000
Actual, FY15, Jan, California, COGS: 20,000
Actual, FY15, Jan, California, Expenses: 5,000

匯入模式:取代,累積類型:檔案內部

Actual, FY15, Jan, California, Sales: 35,000
Actual, FY15, Jan, California, COGS: 20,000
Actual, FY15, Jan, California, Expenses: #MI

另請參閱:匯入模式與累積類型載入資料匯入檔案