Skip to Content
0
Former Member
Feb 14, 2012 at 04:02 AM

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

117 Views

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