加载方法示例

以下示例显示了加载选项的工作方式。假设应用程序中存在以下数据:

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

以下示例显示了使用这些选项组合导入后的数据:

合并,无

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 everything in SYPE combination)

合并,使用数据库

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 the data 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