Skip to Content

BPC Data load - pre aggregation automatically?

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2016 at 05:43 PM

    Hi Maximilian,

    This is the standard behaviour of bpc database...it will only aggregate the data which has all the members of the full cross section same. Even one different member in the record in cross section will be treated as different! Nothing can be changed in this as far as I know......

    If you need aggregation based on profit center then you can write an end routine for the same and run it in transformation file while loading the data.

    Regards,

    JP

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 22, 2016 at 09:23 AM

    First of all the idea to append data on load looks not perfect in general 😊 If for some reason you have to reload data then... 😔

    Can you explain the business logic of append load? You don't have some required dimension to load data separately or...?

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Vadim,

      I hope I get your question right, but the Business logic is that they want to just map a few (actual) accounts (AC2, AC3) into one (planning) account (AC1).

      We never experienced any Trouble with that because there were not completely similar (so the profitcenter was different or something else).

      Here for the first time the data records become completely similar AC2 and AC3 become AC1 and they have the same SEGMENT and PROFITCENTER. So the behaviour of BPC is here to overwrite the value instead of append.

      We could load AC3 separately of course - but that is not the way he wants. That's why i was asking if there is any pre-aggregation option within bpc in the load process on the SOURCE (not target). Or do we have to do this in the transformations of the layers below in the SAP BW?

      Best regards
      Max

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.