Importing Master Data Hierarchy from BW Infobject

[Private_Member_55428]

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

[Jeffrey_Holdema]

In BW the ACCOUNT is compounded to the chart of accounts. Your account hierarchy thus likely contains items which are made up of the concatenation of the chart of accounts with the account. If you try to bring the hierarchy items over to BPC the master data must be present in that form. Otherwise you must transform the data to be consistent. Please post the relevant sections of both transformation files (master data and hierarchy) so we can understand your setup better.

[Jeffrey Holdeman|http://wiki.sdn.sap.com/wiki/display/profile/Jeffrey+Holdeman]

SAP Labs, LLC

BusinessObjects Division

Americas Applications Regional Implementation Group (RIG)

[Private_Member_55428]

Thanks Jeffery Holdeman for that. Tranformation & Coversion files for Mater Data & Hierarchy are listed below.

In my DM package the Hierarchy Tab is Hierarchy = TCTB, EMPTY, Member ID = TB(top most level of taxt hierarchy)

Master Data:

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = TAB

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

*MAPPING

ID=0CS_CHART+ID

*CONVERSION

ID=[COMPANY]id_conversion_01.XLS!CONVERSION

id_conversion.xls is as below:

(- js:%external%.replace("-", "_")

Transformation & Conversion file for Hierarchy:

*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=[COMPANY]hier_conversion_for_account.xls!CONVERSION

NODENAME=[COMPANY]hier_conversion_for_account.xls!NODENAME

PARENT=[COMPANY]hier_conversion_for_account.xls!NODENAME

hier_conversion_for_account.xls is as below:-

Nodesname(worksheet)

External Internal

- js:%external%.toString().replace("-","_")

• * js:%external%.toString().replace(/\s+/g,"")

Conversion(worksheet)

EXTERNAL INTERNAL FORMULA

TCTB PARENTH1