Export transaction data without thousand separator

[UmaArjunan]

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 :

[Former Member]

Hi Uma...

Can you show the screenshot of your output file?

JP

[former_member186338 · Accepted solution]

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

[former_member186338 · Accepted solution]

P.S. I also see ENDROUTINE badi in your transformation file - debug it and you will see the reason!

[UmaArjunan]

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

[UmaArjunan]

Hi JP & Vadim,

Please find the screenprint of the

output file :

[former_member186338]

Sorry, but no screenshot!

[former_member186338]

The file is looking strange, can you download it to the local folder and open in notepad?

Also transformation file is missing!

[former_member186338]

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