Skip to Content
0
Aug 20, 2010 at 03:45 AM

Importing Master Data Hierarchy from BW Infobject

101 Views

I am importing from top level node(text hierarchy) of BW infobject Account. All the records are rejected with the following error. It says that Hierarchy nodes include dimension members that do not exist. The reason for this is that it is top level text hierarchy defined by users. I can import the base level one by one. Any sugestion please. How to docs are not very helpful.

/CPMB/MODIFY completed in 0 seconds

/CPMB/BW_IOBJ_HIER_SOURCE completed in 0 seconds

/CPMB/IOBJ_SOURCE_HD_CONVERT completed in 3 seconds

/CPMB/BPC_HIER_DATA_TARGET completed in 5 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

-


INFOOBJECT=0CS_ITEM

SELECTION=<Selections><Selection Type="Hierarchy" ImportText="1"><Hierarchy><ID>D8IGJYZMI5W3TJ2UBMZGCL6QF</ID><MemberID>TB</MemberID><Level></Level></Hierarchy></Selection><KeyDate>20100820</KeyDate></Selections>

FORMAT= No

TRANSFORMATION= DATAMANAGER\TRANSFORMATIONFILES\PILOT\forHier_Account.xls

DIMNAME=P_ACCT

[Messages]

-


Task name HIERARCHY DATA SOURCE:

Info: Hierarchy node includes text node or external characteristics

Record count: 2724

Task name CONVERT:

No 1 Round:

Record count: 2724

Accept count: 2724

Reject count: 0

Skip count: 0

Task name HIERARCHY DATA TARGET:

Hierarchy nodes include dimension members that do not exist

Submit count: 0

Application: PLANNING Package status: ERROR