Show TOC

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

Note Prerequisites:
  • The target cube contains the Account, Category and Time dimensions.
  • The target data is aggregated prior to the copy 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