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