Skip to Content

Export transaction data without thousand separator

BPC experts,

I am trying to export transaction data from BPC cube to application server as csv file.

WITHOUT thousand separator. For example, 10000.12.

--------------------from Help. sap.-----------------------------

The default setting is that the decimal point of the signed data is a period and there are no thousand separators. For example, 10000.12.

--------------------from Help. sap.------------------------------

I tried the above in my transformation file, but in the output file still thousand separators are displayed. Is there any options to get the amount without thousand separator.

Transformation file used :

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 10, 2017 at 09:15 AM

    From help - statements in transformation file:

    "AMOUNTDECIMALPOINT = Any two characters.

    The first character functions as the decimal point and the second functions as the thousands separator. There should be no space, tab, or any other character between the two characters."

    For export: OUTPUTAMOUNTDECIMALPOINT to be used:

    Read: https://launchpad.support.sap.com/#/notes/1690712/E

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 10, 2017 at 08:28 AM

    Please show the resulting file screenshot in notepad! Not in Excel!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 10, 2017 at 08:49 AM

    Hi JP & Vadim,

    Please find the screenprint of the

    output file :

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2017 at 04:02 AM

    Added OUTPUTAMOUNTDECIMALPOINT=. in the transformation file and it solved my problem.

    Add comment
    10|10000 characters needed characters exceeded