Question Re: SAP BPC Conversion file - using JS code in Financial Management Q&A

SAP BPC Conversion file - using JS code

vsreeja — Wed, 09 Nov 2016 13:04:52 GMT

Hi All,

Please help us with the following scenario.

When we tried to load the transaction data from BW object to BPC, we have one field 'FISCALPER' that we need to convert to BPC format. Conversion logic for the same is as follows:

2006001 --> 2006.07

2006002 --> 2006.08

2006003 ---> 2006.09

2006004 --> 2006.10

2006005 --> 2006.11

2006006 --> 2006.12

2006007 ---> 2007.01

2006008 --> 2007.02

Is it possible to achieve the same using conversion file Java script.?

If so, please guide us.

Thanks and Regards,

Sreeja V

Re: SAP BPC Conversion file - using JS code

former_member186338 — Wed, 09 Nov 2016 13:25:40 GMT

Easy, just search forum. This question was answered many times.

Re: SAP BPC Conversion file - using JS code

vsreeja — Wed, 09 Nov 2016 14:08:34 GMT

Incrementing the year using conversion file is not found in any forum. It wont be 2006 all the time.. This number may change and we cannot hard code the same as well.

????007 ---> (???? year + 1).01

Thanks and Regards,

Sreeja V

Re: SAP BPC Conversion file - using JS code

former_member186338 — Wed, 09 Nov 2016 15:12:04 GMT

Easy:

js:(((parseInt(%external%.toString().slice(0,4))*12+parseInt(%external%.toString().slice(-2))+5)/12)^0).toString()
+"."+("0"+((parseInt(%external%.toString().slice(0,4))*12+parseInt(%external%.toString().slice(-2))+5)%12+1).toString()).slice(-2)