Load Method Examples

The following examples show how the load 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 has the following data:

Entity, Sales, COGS, Point-of-View, Data Load Cube Name

California, 10000, 15000, ("Actual","FY15","Jan"), Consol

California, 25000, 5000, ("Actual","FY15","Jan"), Consol

These examples how the data after the import using these option combinations:

Merge, 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

Replace, None

Actual, FY15, Jan, California, Sales : 25,000

Actual, FY15, Jan, California, COGS : 5,000

Actual, FY15, Jan, California, Expenses : #MI (Replace clears everything in SYPE combination)

Merge, 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

Replace, 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 the data before the import)

Merge, Within File

Actual, FY15, Jan, California, Sales : 35,000

Actual, FY15, Jan, California, COGS : 20,000

Actual, FY15, Jan, California, Expenses : 5,000

Replace, Within File

Actual, FY15, Jan, California, Sales : 35,000

Actual, FY15, Jan, California, COGS : 20,000

Actual, FY15, Jan, California, Expenses : #MI