SAP BPC Transformation / Conversion File

[Former Member]

Hello,

I am currently having an issue in SAP BPC Transformation/Conversion File (loading data from flat file to BPC).

In the Dimension Profit Center, I want to input the following values:

201, 1702

Yet BPC will only recognize 10 Character Number Strings, as follows:

0000000201 , 0000001702

What I have tried so far:

-Using IF condition in Transformation File, although it is difficult because BPC doesn't recognize ">" and "<"
(should read IF(Profit Center>1000; *STR(000000)+PROFIT CENTER; *STR(0000000)+PROFIT CENTER)

-Using JavaScript function parseInt in the Conversion File, yet I am convinced that what I am
trying to do is precisely the opposite of that.

Any suggestions on how to solve this issue?

Thanks,

Miguel Barrera

[former_member186338]

Easy, please read ANY online JavaScript tutorial!

JS: ('0000000000'+external.toString()).slice(-10)

[former_member186338]

And silence...

[Former Member]

Thank you and sorry for the delay!

The problem was solved through Conversion File, as follows:

External

??? and in the row below ????

Internal

0000000??? and in the row below 000000????

[former_member186338]

Very strange solution! Unable to understand why not to use single line JavaScript!