cancel
Showing results for 
Search instead for 
Did you mean: 

Validation with Data File Failed - SAP BPC NW 10.1

0 Kudos

Hello Experts,

I have created a transformation file in BPC to extract transaction data from BW Infocube. To test, if it working correctly or not, I tried to validate and process the file and used the respective cube data from the selection.

I am getting the below attached error:-

From the log displayed above, it seems that there is no issue with mappings and conversions.

Below is the transformation file:-

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=-1

ROUNDAMOUNT=

*MAPPING

ACCOUNT=ZACCOUNT

AUDITTRAIL=ZAUDITTR

CATEGORY=ZCATEGORY

COST_CENTER=ZCOSTCTR

DRIVER=*IF(ZACCOUNT=*STR(0042500003) THEN *STR(S0010);ZDRIVER)

ENTITY=ZENTITY

FLOW=ZFLOW

PRODUCT=ZPRODUCT

REGION=ZWW001

RPTCURRENCY=ZCURRENCY

TIME=ZZTIME

VALUATION=ZVALTN

VENDOR=ZZVENDOR

SIGNEDDATA=ZAMOUNT

*CONVERSION

TIME=TIME.xls

REGION=STATE.xls

FLOW=FLOW.xls

ACCOUNT=ACCOUNT.xls

PRODUCT=PRODUCT.xls

We are using BPC 10.1 NW and BW 740 with Patch 11.

MS-Excel 2016 64-bit and EPM Addin SP 27 Patch 2.

Pls help experts.

Regards

Achyut Sharma

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Try to perform data load and post the log!

Also post screenshots of conversion files.

Answers (0)