wrong number format in export td

[former_member617674]

Hi All,

We use standard export TD to file package to export data from finance module. During one of package runs it occurs BPC uses wrong numeric format (with minus sign at the end of value).

We've recognized the problem occurs only for values between -0.50 and 0.00.

Does anoyne have problem like this? How we can resolve it?

[adamjab1 · Accepted solution]

Implemeting note 1978430 or SP13 seems to be solving a problem.

Regards.

[former_member617674]

Vadim,

My EPM Add-in is BPC10 SP15. Where I can find SP for BW? Our IT department asked me which SP should they check - they stated there is many different service pack for bw??

[former_member617674]

Vadim,

Is it in status window in SAP GUI? If yes, it's 012 - same as you? /

[former_member186338]

And what is core BPC SP? Not EPM! Look in SAP GUI status...

[former_member617674]

Vadim,

Is it CPMBPC component? If it is, its SP12 (SAPK-80012INCPMBPC).

[former_member186338]

At least on SP14 (my current) - no issues (tested).

Vadim

[adamjab1]

Your systems guys do not appear to be comaparable. Vadims BPC runs propably on Microsoft Platform. In Michal case SP12 is the latest servicepack on Netweaver platform

[former_member186338]

Sorry Adam, please don't post incorrect info before checking! My system:

Vadim

[adamjab1]

Sorry, you are right of course. Outdated info on help.sap.com suggested  this mistake as SP012 is presented there for Netwevaer and SP14 for Microsoft. Now checked on downloads and SP14 seems to be latest for NW as well

[former_member186338]

Hi Michal,

Is it reproducible?

Please provide the transformation file.

Vadim

[former_member617674]

Hi Vadim,

Sure it is. Just create new custom model, periodic, with A/C/E/T dimensions and put some data within range -0.5 and 0.0

Next try to export transaction data with simply new created transformation file (below I've put code).

I've just realized that if I changed ROUNDAMOUNT options from default "empty" to some number, it helps - BPC preserve valid format of data. Why it doesn't work with empty parameter?

*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER = ,
AMOUNTDECIMALPOINT = .
SKIP = 0
SKIPIF =
VALIDATERECORDS=YES
CREDITPOSITIVE=YES
MAXREJECTCOUNT=
ROUNDAMOUNT=

*MAPPING

*CONVERSION

[former_member186338]

Just tested - no issues like mentioned. Fresh transformation file with same default settings:

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

*MAPPING

*CONVERSION

Sample string from text file with exported data:

BE1000,DIRECT,2020202010101,2011.JAN,ACTUAL,1200,-0.2300000

My BPC version is BPC10 SP14, BW 730 SP12

Vadim