以下示例显示了导入模式和累计类型选项的工作方式。假设应用程序中存在以下数据：
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