Skip to Content
0

Export Transactional Data from BPC - Conversion Formula not working

Jul 28, 2017 at 06:35 AM

123

avatar image
Former Member

Hello,

We are running BPC 10 NW 731 SP 17 CPM 801 and Excel EPM-Addin (Version 10.0 SP28 Patch 3 Net 4.5).

I want to export periodic transaction data from BPC10.0 NW to flat file. Therefor I use the following Transformationfile and Conversion. I also want to switch the sign of some Accounts. Therefor I use the Formula function in the Conversionfile (2nd Screenshot). This is working fine for the Measure "SIGNEDDATA", but not for all the other (YTD, PERIDIOC, QTD).

Can anyone please suggest how this can be done.

Thank you!

Transformationfile

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=NO

CREDITPOSITIVE=NO

MAXREJECTCOUNT=2

ROUNDAMOUNT=2

SPECIFICMAPPING=YES

*MAPPING

PlanVersion=CATEGORY

Time = TIME

CurrencyCode=CURRENCY

CompanyCode=ENTITY

GLAccount=ACCOUNT

CostCenter=COSTCENTER

Vbund=INTERCO

SIGNEDDATA=SIGNEDDATA

*CONVERSION

GLAccount=EXPORT\ACCOUNT.XLS

CompanyCode=EXPORT\ENTITY.XLS

PlanVersion=EXPORT\CATEGORY.xls

Vbund=EXPORT\INTERCO.XLS

CurrencyCode=EXPORT\CURRENCY.XLS

Conversion File ACCOUNT.XLS

vshhw.png (7.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers