Skip to Content
avatar image
Former Member

Export Transactional Data from BPC - Conversion Formula not working

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers