Question Re: Conversion File Error in Financial Management Q&A

Conversion File Error

Former Member — Fri, 11 Mar 2016 16:14:22 GMT

Hi,

We are using BPC10.1(SP08), BW7.4(SP13) & EPM addin(SP25)

I am facing an issue while loading Master Data for Project Dimension, We need to achieve two conditions:

1) If the BW has .(Period), it should be skip

2) If BW has "/"(Forward Slash), replace Forward Slash with .(Period)

My Conversion File below isnt working:

EXTERNAL	INTERNAL	FORMULA
*	js: %external%.replace("/", ".")
.	*SKIP

My conversion file below works with one record

EXTERNAL	INTERNAL	FORMULA
ABC/789	js: %external%.replace("/", ".")
*	*SKIP

The formula which is working for just one member doesn't work for *

And I have one More Condition, where I need to Pull if the number contains "Period" as well as "Forward Slash"

Please advice,

Thanks,

Hari

Re: Conversion File Error

former_member186338 — Fri, 11 Mar 2016 17:09:23 GMT

Hi Hari,

Nothing will be executed after line:

* JS:...

But I do not understand the logic: What do you want to replace and what do you want to skip.

Please show data examples!

Vadim

Re: Conversion File Error

former_member186338 — Fri, 11 Mar 2016 17:12:15 GMT

P.S.:

Looks like I understood...

Then first skip, then replace:

*.* *SKIP

* js: %external%.replace("/", ".")

P.S. Please sample for: "I need to Pull if the number contains "Period""

Re: Conversion File Error

Former Member — Fri, 11 Mar 2016 17:39:14 GMT

Hi Vadim,

Many Thanks for your reply, It helped me in Solving two conditions while loading Master data, and I have one more condition where I need to bring the data which contains both "." (Period) and "/" (Forward Slash) like

1. A.B -> *SKIP ( Working)

2. A/B -> A.B (Working)

3. A.B/C -> A.B.C (Not able to achieve condition)

Please advice..

Thanks,

Hari

Re: Conversion File Error

former_member186338 — Fri, 11 Mar 2016 17:48:51 GMT

May be:

*.*/* js: %external%.replace("/", ".")

*.*

*SKIP

* js: %external%.replace("/", ".")

not sure...

Vadim

Re: Conversion File Error

Former Member — Tue, 15 Mar 2016 15:45:17 GMT

Hi Vadim,

May thanks, there were only few records with Period and Slash, so I maintained them Manually in the Conversion File...

Thanks,

Hari