Skip to Content
0
Jul 21, 2016 at 02:32 PM

BPC Data load - pre aggregation automatically?

156 Views

Hey Folks,

my question is about transactional data loading (from BW infoprovider, using BPC 10.1 classic) and actual - plan mapping of accounts.

Please regard following case:

Source (Datarecords):

ACCOUNT - SEGMENT - PROFITCENTER - SIGNEDDATA
AC1 SG1 PC1 1

AC2 SG1 PC2 1

AC3 SG1 PC2 1

Conversionfile:

External Internal

AC1 AC1

AC2 AC1

AC3 AC1

In our case we load with overwrite (match key) and it seems to be the case that BPC overwrites already while loading the matching records instead of merging them.

After loading it appears like that:

ACCOUNT - SEGMENT - PROFITCENTER - SIGNEDDATA

AC1 SG1 PC1 1

AC1 SG1 PC2 1

But we would like to have it like:

ACCOUNT - SEGMENT - PROFITCENTER - SIGNEDDATA

AC1 SG1 PC1 1

AC1 SG1 PC2 2

Is there a way to preaggregate so that we get the desired effect of a merge?

Greetz
Max