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