Skip to Content
avatar image
Former Member

BPC error - Failed parse transformation file:unclosed element tag; '>

Apr 25, 2017 at 12:39 PM | 252 Views

Hello Experts,

I am facing this error in BPC while executing a DM package link. I also checked this thread mentioned below. But not relevant for me.

We have similar offline environment both in production and test system where we have the same package link and it runs successfully in test system also we can validate the transformation file successfully. Plz suggest !

SYSTEM Details:

  • BPC 10.1 NW Standard.
  • SAPK-81009INCPMBPC
  • SAPKW74014
  • EPM ADDIN – Version : 10.0 SP 25 Patch 3 .Net3.5

https://archive.sap.com/discussions/thread/3935727

Tranformation file validation:

Package link error:

Transformation file:

Conversion file:

wykaw.png (115.2 kB)
rfs6t.png (79.9 kB)
y0zfa.png (9.4 kB)
howtj.png (14.0 kB)
ljene.png (115.2 kB)
carz1.png (79.9 kB)
SAP Business Planning and Consolidation, version for SAP NetWeaver
navigation
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Vadim Kalinin
    Apr 25, 2017 at 02:28 PM

    And where is you data file sample?

    P.S. Please show it in notepad!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 02, 2017 at 09:10 AM

    Hi Vadim,

    The issue was the .cdm file of the conversion file in BW backend UJFS was corrupted. This was fixed and the issue got resolved. Now we have a different issue. Will comeback with more details soon.

    Regards,Suraj

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin
      May 03, 2017 at 12:24 PM

      Hello Vadim,

      Finally, the issue is resolved and main culprit of the issue was format type in the conversion file. We changed it from DATE to TEXT and it worked. Thanks for all the help and suggestion. Can you help me with some docs or links on Conversion file using java script? Thanks in advance!

      Regards, Suraj Jaiswal

  • avatar image
    Vadim Kalinin
    May 03, 2017 at 12:52 PM

    Just google for any online JavaScript tutorial... On most sites you will also get the online testing tool to execute JavaScript code in the browser window.

    For your case the code will be:

    * js:%external%.toString().slice(-4)+"."+"JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC".substr((%external%.toString().slice(-7,-5)-1)*3,3)

    in the online testing tool test this string:

    alert("30.02.2021".toString().slice(-4)+"."+"JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC".substr(("30.02.2021".toString().slice(-7,-5)-1)*3,3));

    Add comment
    10|10000 characters needed characters exceeded