Transformation Example 
SourceSAP NetWeaver BW InfoObject 0COSTCENTER has defined the following attributes:
0BUS_AREA
0COMPANY_CODE
0LOGSYS
0OBJ_CURR
0PROFIT_CTR
0RESP_PERS
0RT_LOCATIO
0CO_AREA+ID
Destination dimension COSTCENTER is defined in Planning and Consolidation with the following properties:
ID
EVDESCRIPTION
PARENTH1
SCALING
BUS_AREA
COMPANY_CODE
LOGSYS
OBJ_CURR
PROFIT_CTR
RESP_PERS
RT_LOCATIO
Example Conversion File
|
EXTERNAL |
INTERNAL |
FORMULA |
|
*-* |
js: %external%.replace("-", "_") |
This file is saved as ID_CONVERT.XLS. It is used in the transformation file.
Example Transformation File
*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER = TAB
AMOUNTDECIMALPOINT = .
SKIP = 0
SKIPIF =
VALIDATERECORDS=YES
CREDITPOSITIVE=YES
MAXREJECTCOUNT=
ROUNDAMOUNT= *MAPPING
BUS_AREA=0BUS_AREA
COMPANY_CODE=0COMPANY_CODE
LOG_SYS=0LOGSYS
OBJ_CURR=0OBJ_CURR
PROFIT_CTR=0PROFIT_CTR
RESP_PERS=0RESP_PERS
RT_LOCATIO=0RT_LOCATIO
ID=0CO_AREA+ID
*CONVERSION
ID=ID_CONVERT.XLS