Skip to Content
avatar image
Former Member

SAP BPC: Error occurs when loading transaction data from other model

Hi,

I am trying to load transaction data from BW to BPC and getting an error saying

"Error occurs when loading transaction data from other model

Validation with data file failed".

Analysis done so far:

1) We are getting this error for only certain set of data selection. Remaining set of data we are able to load in chunks.

2) Validation of transformation file also failed for the same set of data.

3) Extracted the data to excel and tried loading the data through flat file. Flat file load is working fine.

4) No Non cumulative Key figures in BW Info cube.

5) Have cross checked the master data in BPC for the problematic data set and it is fine.

Need your suggestion in resolving the issue.

Thanks in Advance.

Regards,

Ramesh.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • May 15, 2017 at 02:17 PM

    Hi Ramesh,

    Please provide following details (Screen shots):

    1. Transformation file details. i.e. Options, Mapping & Conversion part.

    2. Selection parameters you are entering before validation.

    Thanks,

    Karan

    Add comment
    10|10000 characters needed characters exceeded

  • May 15, 2017 at 02:26 PM

    Also required:

    DM package log (including rejected records)

    Sample of problematic data

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 15, 2017 at 03:27 PM

    Hi Karan & Vadim,

    Please find the screenshot of the transformation file and sample rejected records. No rejected records are listed in the package log after the execution.

    screenshot.jpg

    Regards,

    Ramesh.

    Add comment
    10|10000 characters needed characters exceeded

    • Sorry, but the attached picture is not readable (low resolution)!

      Please attach screenshots individually using "Insert Image" button.

      Full DM log required!

      All conversion files required

      Selection screens missing!

  • May 16, 2017 at 05:09 AM

    Hi Ramesh,

    Please provide screens shot for selection parameters and rejected list / records in DMP log (see attached example).

    selection-parameters.png

    rejected-list.png

    Thanks,

    Karan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 17, 2017 at 12:59 PM

    Hi All,

    Sorry for the delayed response.

    Issue is resolved now. We have four currency key Columns in BW Info cube (GC1Key, GC2Key, GC3Key, GC4Key). While loading data into BPC, we have mapped currency dimension to GC1Key1 only.

    GC1Key in BW and BPC Currency Dimension are in sync. But some of the currencies of GC2Key, GC3Key and GC4Key in BW are not available in BPC Currency Dimension. After adding those currencies into BPC Currency Dimension, issue is resolved.

    But still not able to understand how the columns which are not relevant in our BPC loads are making an impact here.

    Thanks & Regards,

    Ramesh.

    Add comment
    10|10000 characters needed characters exceeded