Skip to Content
0

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

May 15, 2017 at 02:09 PM

356

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

karan kothari May 15, 2017 at 02:17 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin May 15, 2017 at 02:26 PM
0

Also required:

DM package log (including rejected records)

Sample of problematic data

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 15, 2017 at 03:27 PM
0

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.


screenshot.jpg (67.2 kB)
Show 1 Share
10 |10000 characters needed characters left 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!

0
karan kothari May 16, 2017 at 05:09 AM
0

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


Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 17, 2017 at 12:59 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Sorry, but you are not providing full info. No way to help!

0