Skip to Content

Validation with Data File Failed - SAP BPC NW 10.1

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

capture.png (24.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 26, 2018 at 07:21 AM

    Try to perform data load and post the log!

    Also post screenshots of conversion files.

    Add comment
    10|10000 characters needed characters exceeded