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