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