Import Hierarchy from BW to BPC NW 10.0 SP12

[Former Member]

Hello Experts,

I am trying to import master data hierachy from BW to BPC using IMPORT_IOBJ_HIER process chain.

I am getting following error while package run.

　

/CPMB/MODIFY completed in 0 seconds

/CPMB/BW_IOBJ_HIER_SOURCE completed in 0 seconds

/CPMB/IOBJ_SOURCE_HD_CONVERT completed in 1 seconds

/CPMB/BPC_HIER_DATA_TARGET completed in 0 seconds

[Selection]

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

INFOOBJECT = 0PROFIT_CTR

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>KS17S0U8R9ETK8GPT74YXB3N0</ID><MemberID>0750GMS</MemberID><Level>06</Level><HierName>0750GMS</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy></Selection><KeyDate>20160602</KeyDate></Selections>

WRITEMODE = Yes

FORMAT = Yes

TRANSFORMATION = \ROOT\WEBFOLDERS\BPC_SE_FI_RepCon01\SEXXX

_ACTUAL\DATAMANAGER\TRANSFORMATIONFILES\TRANSACTION_DATA\PRC_HIER_1.xls

DIMNAME = PRC

DIMNAME_KEYDATE =

DIMNAME_DATEFROM =

　

[Message]

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

Task name HIERARCHY DATA SOURCE:

Info: Hierarchy node includes text node or external characteristics

Record count: 1391

Task name CONVERT:

No 1 Round:

Reject count: 0

Record count: 1391

Skip count: 0

Accept count: 1391

Task name HIERARCHY DATA TARGET:

Hierarchy GMS does not exist in BPC

model: SEXXX

_ACTUAL. Package status: ERROR

　

Request you to please help me onm same.

I have prepared following transformation file:

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = TAB

SUPPRESSCHARACTER=0750

*MAPPING

NODENAME=NODENAME

HIER_NAME=HIER_NAME

PARENT=PARENT

ORDER=ORDER

*CONVERSION

HIER_NAME=PRC_HIER.xls!CONVERSION

NODENAME=PRC_HIER.xls!NODENAME

HIER_NAME=PRC_HIER.xls!NODENAME

Let me know in case you require more information.

Regards,

Apoorva

[Former Member · Accepted solution]

Hi Apoorva,

What is the hierarchy name?

the one you use named GSM is not valid in BPC as it states.

I think what is happening is that you use SUPPRESSCHARACTER=0750 that might cause the issue, your hierarchy is name 0750GSM and now 0750 get ignored.

Andy