BW hierarchy load to BPC(Failed parse transformation file:unexpected symbol

[Former Member]

Hi Friends,

Trying to load costcenter(0COSTCENTER) hierarchy data to P_CC(BPC costcenter dim)

TRANSFORMATION file:

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = TAB

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

*MAPPING

NODENAME=NODENAME

HIER_NAME=HIER_NAME

PARENT=PARENT

ORDER=ORDER

IOBJNM=IOBJNM

VERSION=VERSION

*CONVERSION

HIER_NAME=HIER_NAME.xls

NODENAME=HIER_NAME.xls!

NODE_NAME PARENT=HIER_NAME.xls!NODE_NAME

-

---

CONVERSION file:

TAB1: Instructions

External| Internal |Formula

BW hierarchy | PARENTH1 |

TAB2: NODE_NAME

External| Internal |Formula

• |js:%external%.toString().replace(/\s+/g,"")

-

---

Upon validating transformation file getting error message:

Failed parse transformation file:unexpected symbol: '>'

Can anyone share your inputs.

Thanks,

naresh

[Former Member]

Issue resolved and hierarchy succuessfully loaded.

Points;

First load base members using master data/texts package. NO conversion file. Use import text node option.

Second load hierarchy with a converison file.

First conv file: bw hierarchy name mapped to PARENTH1

Second conv file: one dummy with simple java script.

[Former Member]

Now i'm getting below error message:

Info: Hierarchy node includes text node or external characteristics

Java scription JS:%EXTERNAL%.split(' ').join(u201C) evaluation error

Java scription JS:%EXTERNAL%.split(' ').join(u201C) evaluation error

Java scription JS:%EXTERNAL%.split(' ').join(u201C) evaluation error

Java scription JS:%EXTERNAL%.split(' ').join(u201C) evaluation error

---

--

Rejected count 212...

I adjusted converion file as like this:

TAB2: NODE_NAME

External| Internal |Formula

• | js:%external%.split(' ').join(u201C)

- | js:%external%.replace("-","_")

• | js:%external%.toString().replace(/\s+/g,"")

Trasnformation file: conversion section

*CONVERSION

HIER_NAME=HIER_NAME.xls

NODENAME=HIER_NAME.xls!NODE_NAME

PARENT=HIER_NAME.xls!NODE_NAME

Thanks..