Error loading hierarchy in BPC 10

185 Views

Hi Guys

I am trying to load Hiearchy from 0COSTCENTER but the load fails. The validation of transformation file goes through but the actual data package run fails. I have been pointed to changing the compounding of the object (which might be a problem, as BW compounds costcentre and controlling area i.e. 4800 becomes OA054800, OA05 is controlling area ).

Is there any special way to load hierarchy in BPC 10?

I have tried it with ZCSTCENTR (where there is no compounding), the load fails. The transformation file for hierarchy is attached below:

*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=ZCSTCENTR_HIERARCHY_CONVERSION.xls

The conversion file maps the hiearchy name to PARENTH1. The error file is as below:

CPMB/MODIFY completed in 0 seconds

/CPMB/BW_IOBJ_HIER_SOURCE completed in 0 seconds

/CPMB/IOBJ_SOURCE_HD_CONVERT completed in 0 seconds

/CPMB/BPC_HIER_DATA_TARGET completed in 0 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

--------------------------------------------------------------

INFOOBJECT = ZCSTCENTR

SELECTION = <?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Selection Type="Hierarchy" ImportText="0"><Hierarchy><ID>L4DM7809BETMY71F01W30ZBCI</ID><MemberID>OIL_TOP_NODE</MemberID><Level /></Hierarchy></Selection><KeyDate>20120911</KeyDate></Selections>

WRITEMODE = 2

FORMAT = Yes

TRANSFORMATION = \ROOT\WEBFOLDERS\Sumit_Training\SALES_PLANNING\DATAMANAGER\TRANSFORMATIONFILES\SUMIT_TRANSFORMATION\ZCOSTCENTER_HIER_TRANSFORMATION.xls

DIMNAME = S_COSTCENTER

[Message]

--------------------------------------------------------------

Task name HIERARCHY DATA SOURCE:

Info: Hierarchy node includes text node or external characteristics

Record count: 34

Task name CONVERT:

No 1 Round:

Reject count: 0

Record count: 34

Skip count: 0

Accept count: 34

Task name HIERARCHY DATA TARGET:

Submit count: 0

model: SALES_PLANNING. Package status: ERROR

Please see if you can help.

Thanks

Sumit