Import Mode and Accumulation Type Examples
The following examples show how the import mode and accumulation type options work. Suppose the following data exists in the application:
Actual, FY15, Jan, California, Sales: 20,000
Actual, FY15, Jan, California, COGS: 10,000
Actual, FY15, Jan, California, Expenses: 5,000
A load file with the below content is imported:
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
Note:
The import will not overwrite existing data values with #MISSING or blank values. The last row in the data file will have no impact on data in the system.These examples show the data after the import using these option combinations:
Import Mode: Merge, Accumulation Type: None
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
Import Mode: Replace, Accumulation Type: None
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)
Import Mode: Merge, Accumulation Type: With Database
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
Import Mode: Replace, Accumulation Type: With Database
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)
Import Mode: Merge, Accumulation Type: Within File
Actual, FY15, Jan, California, Sales: 35,000
Actual, FY15, Jan, California, COGS: 20,000
Actual, FY15, Jan, California, Expenses: 5,000
Import Mode: Replace, Accumulation Type: Within File
Actual, FY15, Jan, California, Sales: 35,000
Actual, FY15, Jan, California, COGS: 20,000
Actual, FY15, Jan, California, Expenses: #MI
See also: Import Modes and Accumulation Types and Loading the Data Import File