Show TOC

Example documentationImport Transaction Data from an Information Provider Example Locate this document in the navigation structure

 

Prerequisites

The target cube contains the Account, Category and Time dimensions.

The target data is aggregated prior to the copy process.

Process

The data imported from the information provider overwrites the records in the cube that have matching keys. The records in the post-import cube are affected (but the data from the information provider is not affected). If there are duplicate records in the data from the information provide, all the duplicate records are aggregated, using all of the dimensions as the key.

Post-Mapping Information Provider Data

ACTUAL,CASH,2006.JAN,500

ACTUAL,CASH,2006.JAN,200

ACTUAL,CASH,2006.FEB,200

Pre-Import Cube Data

ACTUAL,CASH,2006.FEB,100

ACTUAL,CASH,2006.JAN,200

ACTUAL,CASH,2006.APR,900

Result

Post-Import Cube Data

ACTUAL,CASH,2006.FEB,200

ACTUAL,CASH,2006.JAN,700

ACTUAL,CASH,2006.APR,900