cancel
Showing results for 
Search instead for 
Did you mean: 

Master Data Hierarchy Load from BW to BPC NW 10

Former Member
0 Kudos

Hello Experts,

I have succcessfully loaded entity master data ID from BW to BPC.

Now i am trying to load hierarchy from BW to BPC using following transformation file and conversion file:

*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER = TAB
MAXREJECTCOUNT=1000
SUPPRESSCHARACTER=R70750
*MAPPING
NODENAME=*IF(NODENAME(1:4)=*STR(0750) then NODENAME(5:14);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

Conversion file:

But I am getting following error while package run:

[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 /><HierName>0750GMS</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy></Selection><KeyDate>20160602</KeyDate></Selections>

WRITEMODE = Yes

FORMAT = No

TRANSFORMATION = \ROOT\WEBFOLDERS\BPC_SE_FI_RepCon01\SEABB_ACTUAL\DATAMANAGER\TRANSFORMATIONFILES\MASTER_DATA\PRC_HIER_BID.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: 282

Record count: 1391

Skip count: 0

Accept count: 1109

Task name HIERARCHY DATA TARGET:

Member G-SEABBGEM of dimension PRC has an invalid hierarchy parent '0750GMS'

Member P10110 of dimension PRC has an invalid hierarchy parent '0750G-VALUTA'

Member P10000 of dimension PRC has an invalid hierarchy parent '0750G-OVR'

Member P10111 of dimension PRC has an invalid hierarchy parent '0750G-VALUTA'

Member DUMMY PL of dimension PRC has an invalid hierarchy parent '0750INAKTIVE'

Member BS0001 of dimension PRC has an invalid hierarchy parent '0750G-OVR'

Member P10112 of dimension PRC has an invalid hierarchy parent '0750G-VALUTA'

Member P56113 of dimension PRC has an invalid hierarchy parent '0750PG4113MS'

Member TRAVEL of dimension PRC has an invalid hierarchy parent '0750G-OVR'

Member P10113 of dimension PRC has an invalid hierarchy parent '0750G-VALUTA'

Member P56501 of dimension PRC has an invalid hierarchy parent '0750PG4131LM'

Member P56114 of dimension PRC has an invalid hierarchy parent '0750PG4114MS'

Member PG4113REGS of dimension PRC has an invalid hierarchy parent '0750PG4113REG'

Member P56313 of dimension PRC has an invalid hierarchy parent '0750PG4113MS'

Member YCASH of dimension PRC has an invalid hierarchy parent '0750G-OVR'

Member P10114 of dimension PRC has an invalid hierarchy parent '0750G-VALUTA'

Member P13120 of dimension PRC has an invalid hierarchy parent '0750PG4494FU'

Member 58400 of dimension PRC has an invalid hierarchy parent '0750PG3140'

Member P11410 of dimension PRC has an invalid hierarchy parent '0750PG3122LC'

Member PG3107REGM of dimension PRC has an invalid hierarchy parent '0750PG3107REG'

Member P58190 of dimension PRC has an invalid hierarchy parent '0750PG3103CL'

Member P56117 of dimension PRC has an invalid hierarchy parent '0750PG4117MS'

Member P12030 of dimension PRC has an invalid hierarchy parent '0750PG4133M'

Member P56131 of dimension PRC has an invalid hierarchy parent '0750PG4131MS'

Member P56120 of dimension PRC has an invalid hierarchy parent '0750PG4120MS'

Member P56314 of dimension PRC has an invalid hierarchy parent '0750PG4114MS'

Member PG4113REGM of dimension PRC has an invalid hierarchy parent '0750PG4113REG'

Member P13074 of dimension PRC has an invalid hierarchy parent '0750PG4113REGS'

Member PL0001 of dimension PRC has an invalid hierarchy parent '0750G-OVR'

Member PG2108STAB of dimension PRC has an invalid hierarchy parent '0750PG2108'

Member P32000 of dimension PRC has an invalid hierarchy parent '0750PG2108B'

Member P11150 of dimension PRC has an invalid hierarchy parent '0750PG7709K'

Member P13130 of dimension PRC has an invalid hierarchy parent '0750PG4494FU'

Member 58410 of dimension PRC has an invalid hierarchy parent '0750PG3143'

Member P58370 of dimension PRC has an invalid hierarchy parent '0750PG3136CL'

Member P58110 of dimension PRC has an invalid hierarchy parent '0750PG3122CL'

Member P59030 of dimension PRC has an invalid hierarchy parent '0750PG3114DON'

Member P58195 of dimension PRC has an invalid hierarchy parent '0750PG3107CL'

Member PG3107REGN of dimension PRC has an invalid hierarchy parent '0750PG3107REG'

Member P13515 of dimension PRC has an invalid hierarchy parent '0750PG3107REGM'

Member P58210 of dimension PRC has an invalid hierarchy parent '0750PG3103CL'

Member PG4161CENT of dimension PRC has an invalid hierarchy parent '0750PG4161'

Member P46010 of dimension PRC has an invalid hierarchy parent '0750PG4313BE'

Member PG4129REGM of dimension PRC has an invalid hierarchy parent '0750PG4129REG'

Member P56128 of dimension PRC has an invalid hierarchy parent '0750PG4117MS'

Member P56130 of dimension PRC has an invalid hierarchy parent '0750PG4138MS'

Member P56400 of dimension PRC has an invalid hierarchy parent '0750PG4133CSN'

Member P11411 of dimension PRC has an invalid hierarchy parent '0750PG4131LC'

Member P56331 of dimension PRC has an invalid hierarchy parent '0750PG4131MS'

Member P11412 of dimension PRC has an invalid hierarchy parent '0750PG4124LC'

Member P56320 of dimension PRC has an invalid hierarchy parent '0750PG4120MS'

Member PG4113REGN of dimension PRC has an invalid hierarchy parent '0750PG4113REG'

Member P13364 of dimension PRC has an invalid hierarchy parent '0750PG4113REGM'

Member DUMMY-M of dimension PRC has an invalid hierarchy parent '0750G-OVR'

Member P21200 of dimension PRC has an invalid hierarchy parent '0750PG2212'

Member PG2211PPST of dimension PRC has an invalid hierarchy parent '0750PG2211'

Member P21000 of dimension PRC has an invalid hierarchy parent '0750PG2211DC'

Member P51345 of dimension PRC has an invalid hierarchy parent '0750PG3410SF'

Member P34000 of dimension PRC has an invalid hierarchy parent '0750PG2111BC'

Member P30000 of dimension PRC has an invalid hierarchy parent '0750PG2108STAB'

Member P11123 of dimension PRC has an invalid hierarchy parent '0750PG3199O'

Member P11152 of dimension PRC has an invalid hierarchy parent '0750PG7715K'

Member P11151 of dimension PRC has an invalid hierarchy parent '0750PG7709K'

Member P13140 of dimension PRC has an invalid hierarchy parent '0750PG4494FU'

Member P58150 of dimension PRC has an invalid hierarchy parent '0750PG3132CL'

Member P58375 of dimension PRC has an invalid hierarchy parent '0750PG3136CL'

Member P58120 of dimension PRC has an invalid hierarchy parent '0750PG3122CL'

Member P59031 of dimension PRC has an invalid hierarchy parent '0750PG3114DON'

Member PG3107REGS of dimension PRC has an invalid hierarchy parent '0750PG3107REG'

Member P13705 of dimension PRC has an invalid hierarchy parent '0750PG3107REGN'

Member P13525 of dimension PRC has an invalid hierarchy parent '0750PG3107REGM'

Member P58215 of dimension PRC has an invalid hierarchy parent '0750PG3103CL'

Member P56000 of dimension PRC has an invalid hierarchy parent '0750PG4161CENT'

Member P46810 of dimension PRC has an invalid hierarchy parent '0750PG4314FE'

Member P46020 of dimension PRC has an invalid hierarchy parent '0750PG4313BE'

Member PG4159REGM of dimension PRC has an invalid hierarchy parent '0750PG4159REG'

Member PG4129REGN of dimension PRC has an invalid hierarchy parent '0750PG4129REG'

Member P13368 of dimension PRC has an invalid hierarchy parent '0750PG4129REGM'

Member P56317 of dimension PRC has an invalid hierarchy parent '0750PG4117MS'

Member P56139 of dimension PRC has an invalid hierarchy parent '0750PG4139MS'

Member P12021 of dimension PRC has an invalid hierarchy parent '0750PG4138M'

Member P56138 of dimension PRC has an invalid hierarchy parent '0750PG4138MS'

Member P56133 of dimension PRC has an invalid hierarchy parent '0750PG4133MS'

Member P56403 of dimension PRC has an invalid hierarchy parent '0750PG4133CSN'

Member P12010 of dimension PRC has an invalid hierarchy parent '0750PG4131M'

Member P11413 of dimension PRC has an invalid hierarchy parent '0750PG4131LC'

Member P13006 of dimension PRC has an invalid hierarchy parent '0750PG4124REG'

Member PG4113REGV of dimension PRC has an invalid hierarchy parent '0750PG4113REG'

Member P13764 of dimension PRC has an invalid hierarchy parent '0750PG4113REGN'

Member P13384 of dimension PRC has an invalid hierarchy parent '0750PG4113REGM'

Member P17385 of dimension PRC has an invalid hierarchy parent '0750PG9957RE'

Member P24010 of dimension PRC has an invalid hierarchy parent '0750PG2872NM'

Member PG2211PSST of dimension PRC has an invalid hierarchy parent '0750PG2211'

Member P20500 of dimension PRC has an invalid hierarchy parent '0750PG2211PPST'

Member P11414 of dimension PRC has an invalid hierarchy parent '0750PG3442LC'

Member P31000 of dimension PRC has an invalid hierarchy parent '0750PG2127A'

Member P34500 of dimension PRC has an invalid hierarchy parent '0750PG2111DON'

Member P30010 of dimension PRC has an invalid hierarchy parent '0750PG2108STAB'

Member P11102 of dimension PRC has an invalid hierarchy parent '0750PG4166J'

Member P11200 of dimension PRC has an invalid hierarchy parent '0750PG4442FM'

Member P58611 of dimension PRC has an invalid hierarchy parent '0750PG3199O'

Member P11153 of dimension PRC has an invalid hierarchy parent '0750PG7709K'

Member P13330 of dimension PRC has an invalid hierarchy parent '0750PG4494FU'

Member P57111 of dimension PRC has an invalid hierarchy parent '0750PG3101LS'

Member P58220 of dimension PRC has an invalid hierarchy parent '0750PG3132CL'

Member P58380 of dimension PRC has an invalid hierarchy parent '0750PG3136CL'

Member P58130 of dimension PRC has an invalid hierarchy parent '0750PG3122CL'

Member PG3107REGV of dimension PRC has an invalid hierarchy parent '0750PG3107REG'

Member P13015 of dimension PRC has an invalid hierarchy parent '0750PG3107REGS'

Member P13715 of dimension PRC has an invalid hierarchy parent '0750PG3107REGN'

Member P13535 of dimension PRC has an invalid hierarchy parent '0750PG3107REGM'

Member P58310 of dimension PRC has an invalid hierarchy parent '0750PG3103CL'

Member P47010 of dimension PRC has an invalid hierarchy parent '0750PG4333RSP'

Member P48010 of dimension PRC has an invalid hierarchy parent '0750PG4314RA'

Member P46820 of dimension PRC has an invalid hierarchy parent '0750PG4314FE'

Member P46030 of dimension PRC has an invalid hierarchy parent '0750PG4313BE'

Member PG4159REGN of dimension PRC has an invalid hierarchy parent '0750PG4159REG'

Member P13358 of dimension PRC has an invalid hierarchy parent '0750PG4159REGM'

Member P13378 of dimension PRC has an invalid hierarchy parent '0750PG4129REGM'

Member P56328 of dimension PRC has an invalid hierarchy parent '0750PG4117MS'

Member P56156 of dimension PRC has an invalid hierarchy parent '0750PG4156MS'

Member P12001 of dimension PRC has an invalid hierarchy parent '0750PG4139M'

Member P56339 of dimension PRC has an invalid hierarchy parent '0750PG4139MS'

Member P12022 of dimension PRC has an invalid hierarchy parent '0750PG4138M'

Member P56330 of dimension PRC has an invalid hierarchy parent '0750PG4138MS'

Member P56500 of dimension PRC has an invalid hierarchy parent '0750PG4133LM'

Member P56134 of dimension PRC has an invalid hierarchy parent '0750PG4133MS'

Member P56404 of dimension PRC has an invalid hierarchy parent '0750PG4133CSN'

Member P13005 of dimension PRC has an invalid hierarchy parent '0750PG4131REG'

Member P12050 of dimension PRC has an invalid hierarchy parent '0750PG4131M'

Member PG4124REGM of dimension PRC has an invalid hierarchy parent '0750PG4124REG'

Member P13194 of dimension PRC has an invalid hierarchy parent '0750PG4113REGV'

Member P13784 of dimension PRC has an invalid hierarchy parent '0750PG4113REGN'

Member P17520 of dimension PRC has an invalid hierarchy parent '0750PG9953RD'

Member P18152 of dimension PRC has an invalid hierarchy parent '0750PG9958RE'

Member P17386 of dimension PRC has an invalid hierarchy parent '0750PG9957RE'

Member P29010 of dimension PRC has an invalid hierarchy parent '0750PG2875SA'

Member P25010 of dimension PRC has an invalid hierarchy parent '0750PG2872NM'

Member P28010 of dimension PRC has an invalid hierarchy parent '0750PG2214OWC'

Member P20030 of dimension PRC has an invalid hierarchy parent '0750PG2211PSST'

Member P20510 of dimension PRC has an invalid hierarchy parent '0750PG2211PPST'

Member PG2408STAB of dimension PRC has an invalid hierarchy parent '0750PG2408'

Member P50250 of dimension PRC has an invalid hierarchy parent '0750PG2408PT'

Member P51330 of dimension PRC has an invalid hierarchy parent '0750PG3446SF'

Member P13609 of dimension PRC has an invalid hierarchy parent '0750PG3442REG'

Member P37000 of dimension PRC has an invalid hierarchy parent '0750PG2128CAP'

Member PG2127STAB of dimension PRC has an invalid hierarchy parent '0750PG2127'

Member P39010 of dimension PRC has an invalid hierarchy parent '0750PG2127G'

Member P11100 of dimension PRC has an invalid hierarchy parent '0750PG4177G'

Member P11105 of dimension PRC has an invalid hierarchy parent '0750PG4167V'

Member P11111 of dimension PRC has an invalid hierarchy parent '0750PG4166V'

Member P11103 of dimension PRC has an invalid hierarchy parent '0750PG4166J'

Member P11122 of dimension PRC has an invalid hierarchy parent '0750PG3129O'

Member P11201 of dimension PRC has an invalid hierarchy parent '0750PG4442FM'

Member P58612 of dimension PRC has an invalid hierarchy parent '0750PG3199O'

Member P13650 of dimension PRC has an invalid hierarchy parent '0750PG4494FU'

Member PG3131CENT of dimension PRC has an invalid hierarchy parent '0750PG3131'

Member P58270 of dimension PRC has an invalid hierarchy parent '0750PG3121CL'

Member PG3102REGM of dimension PRC has an invalid hierarchy parent '0750PG3102REG'

Member P57112 of dimension PRC has an invalid hierarchy parent '0750PG3101LS'

Member P58225 of dimension PRC has an invalid hierarchy parent '0750PG3132CL'

Member P58385 of dimension PRC has an invalid hierarchy parent '0750PG3136CL'

Member P58140 of dimension PRC has an invalid hierarchy parent '0750PG3122CL'

Member P13214 of dimension PRC has an invalid hierarchy parent '0750PG3107REGV'

Member P13545 of dimension PRC has an invalid hierarchy parent '0750PG3107REGM'

Member P58320 of dimension PRC has an invalid hierarchy parent '0750PG3103CL'

Member P14051 of dimension PRC has an invalid hierarchy parent '0750PG4333RS'

Member P47020 of dimension PRC has an invalid hierarchy parent '0750PG4333RSP'

Member P14170 of dimension PRC has an invalid hierarchy parent '0750PG4314AC'

Member P48020 of dimension PRC has an invalid hierarchy parent '0750PG4314RA'

Member P46830 of dimension PRC has an invalid hierarchy parent '0750PG4314FE'

Member P46210 of dimension PRC has an invalid hierarchy parent '0750PG4313BE'

Member PG4159REGS of dimension PRC has an invalid hierarchy parent '0750PG4159REG'

Member P13768 of dimension PRC has an invalid hierarchy parent '0750PG4159REGN'

Member P13388 of dimension PRC has an invalid hierarchy parent '0750PG4159REGM'

Member P56157 of dimension PRC has an invalid hierarchy parent '0750PG4157MS'

Member P12040 of dimension PRC has an invalid hierarchy parent '0750PG4156M'

Member P56356 of dimension PRC has an invalid hierarchy parent '0750PG4156MS'

Member P12020 of dimension PRC has an invalid hierarchy parent '0750PG4139M'

Member P56338 of dimension PRC has an invalid hierarchy parent '0750PG4138MS'

Member P56503 of dimension PRC has an invalid hierarchy parent '0750PG4133LM'

Member P56141 of dimension PRC has an invalid hierarchy parent '0750PG4133MS'

Member PG4131REGM of dimension PRC has an invalid hierarchy parent '0750PG4131REG'

Member PG4124REGN of dimension PRC has an invalid hierarchy parent '0750PG4124REG'

Member P13310 of dimension PRC has an invalid hierarchy parent '0750PG4124REGM'

Member P17210 of dimension PRC has an invalid hierarchy parent '0750PG9907CO2'

Member P17540 of dimension PRC has an invalid hierarchy parent '0750PG9953RD'

Member P18153 of dimension PRC has an invalid hierarchy parent '0750PG9959RE'

Member P18100 of dimension PRC has an invalid hierarchy parent '0750PG9957RE'

Member P24120 of dimension PRC has an invalid hierarchy parent '0750PG1722PG'

Member P26010 of dimension PRC has an invalid hierarchy parent '0750PG2877TP'

Member P23040 of dimension PRC has an invalid hierarchy parent '0750PG2875SS'

Member P29020 of dimension PRC has an invalid hierarchy parent '0750PG2875SA'

Member P25020 of dimension PRC has an invalid hierarchy parent '0750PG2872NM'

Member PG2215PSST of dimension PRC has an invalid hierarchy parent '0750PG2215'

Member P20000 of dimension PRC has an invalid hierarchy parent '0750PG2211PSST'

Member P20520 of dimension PRC has an invalid hierarchy parent '0750PG2211PPST'

Member P50330 of dimension PRC has an invalid hierarchy parent '0750PG2413TR'

Member P50020 of dimension PRC has an invalid hierarchy parent '0750PG2408STAB'

Member P50300 of dimension PRC has an invalid hierarchy parent '0750PG2408PT'

Member P51331 of dimension PRC has an invalid hierarchy parent '0750PG3446SF'

Member PG3442REGM of dimension PRC has an invalid hierarchy parent '0750PG3442REG'

Member P33000 of dimension PRC has an invalid hierarchy parent '0750PG2132'

Member P38010 of dimension PRC has an invalid hierarchy parent '0750PG2129I'

Member P37200 of dimension PRC has an invalid hierarchy parent '0750PG2128CAP'

Member P30020 of dimension PRC has an invalid hierarchy parent '0750PG2127STAB'

Member P11120 of dimension PRC has an invalid hierarchy parent '0750PG4413O'

Member PG4196REGM of dimension PRC has an invalid hierarchy parent '0750PG4196REG'

Member P11101 of dimension PRC has an invalid hierarchy parent '0750PG4177G'

Member PG4167REGM of dimension PRC has an invalid hierarchy parent '0750PG4167REG'

Member P11108 of dimension PRC has an invalid hierarchy parent '0750PG4167V'

Member P11110 of dimension PRC has an invalid hierarchy parent '0750PG4166J'

Member P11202 of dimension PRC has an invalid hierarchy parent '0750PG3129FM'

Member P58617 of dimension PRC has an invalid hierarchy parent '0750PG3129O'

Member P11203 of dimension PRC has an invalid hierarchy parent '0750PG4442FM'

Member P58613 of dimension PRC has an invalid hierarchy parent '0750PG3199O'

Member P13651 of dimension PRC has an invalid hierarchy parent '0750PG4494FU'

Member P58000 of dimension PRC has an invalid hierarchy parent '0750PG3131CENT'

Member P58280 of dimension PRC has an invalid hierarchy parent '0750PG3121CL'

Member P57211 of dimension PRC has an invalid hierarchy parent '0750PG3102LS'

Member PG3102REGN of dimension PRC has an invalid hierarchy parent '0750PG3102REG'

Member P13514 of dimension PRC has an invalid hierarchy parent '0750PG3102REGM'

Member P57121 of dimension PRC has an invalid hierarchy parent '0750PG3101LS'

Member P58240 of dimension PRC has an invalid hierarchy parent '0750PG3132CL'

Member P58160 of dimension PRC has an invalid hierarchy parent '0750PG3122CL'

Member P13595 of dimension PRC has an invalid hierarchy parent '0750PG3107REGM'

Member P58330 of dimension PRC has an invalid hierarchy parent '0750PG3103CL'

Member P14102 of dimension PRC has an invalid hierarchy parent '0750PG4333RS'

Member P47030 of dimension PRC has an invalid hierarchy parent '0750PG4333RSP'

Member P48600 of dimension PRC has an invalid hierarchy parent '0750PG4314AC'

Member P48030 of dimension PRC has an invalid hierarchy parent '0750PG4314RA'

Member P46840 of dimension PRC has an invalid hierarchy parent '0750PG4314FE'

Member P46310 of dimension PRC has an invalid hierarchy parent '0750PG4313BE'

Member PG4159REGV of dimension PRC has an invalid hierarchy parent '0750PG4159REG'

Member P13078 of dimension PRC has an invalid hierarchy parent '0750PG4159REGS'

Member P13783 of dimension PRC has an invalid hierarchy parent '0750PG4159REGN'

Member P13393 of dimension PRC has an invalid hierarchy parent '0750PG4159REGM'

Member P56357 of dimension PRC has an invalid hierarchy parent '0750PG4157MS'

Member P12023 of dimension PRC has an invalid hierarchy parent '0750PG4139M'

Member P56504 of dimension PRC has an invalid hierarchy parent '0750PG4133LM'

Member P56333 of dimension PRC has an invalid hierarchy parent '0750PG4133MS'

Member PG4131REGN of dimension PRC has an invalid hierarchy parent '0750PG4131REG'

Member P13280 of dimension PRC has an invalid hierarchy parent '0750PG4131REGM'

Member PG4124REGS of dimension PRC has an invalid hierarchy parent '0750PG4124REG'

Member P13680 of dimension PRC has an invalid hierarchy parent '0750PG4124REGN'

Member P13350 of dimension PRC has an invalid hierarchy parent '0750PG4124REGM'

Member P17410 of dimension PRC has an invalid hierarchy parent '0750PG9908CO2'

Member P17220 of dimension PRC has an invalid hierarchy parent '0750PG9907CO2'

Member P17541 of dimension PRC has an invalid hierarchy parent '0750PG9953RD'

Member P18101 of dimension PRC has an invalid hierarchy parent '0750PG9957RE'

Member P23010 of dimension PRC has an invalid hierarchy parent '0750PG2871SS'

Member P24130 of dimension PRC has an invalid hierarchy parent '0750PG1723PG'

Member P23080 of dimension PRC has an invalid hierarchy parent '0750PG1722SS'

Member P26020 of dimension PRC has an invalid hierarchy parent '0750PG2877TP'

Member P23060 of dimension PRC has an invalid hierarchy parent '0750PG2875SS'

Member P25030 of dimension PRC has an invalid hierarchy parent '0750PG2872NM'

Member P22000 of dimension PRC has an invalid hierarchy parent '0750PG2217FA'

Member P20530 of dimension PRC has an invalid hierarchy parent '0750PG2211PPST'

Member P53010 of dimension PRC has an invalid hierarchy parent '0750PG2425CO'

Member PG2413REGM of dimension PRC has an invalid hierarchy parent '0750PG2413REG'

Member P50350 of dimension PRC has an invalid hierarchy parent '0750PG2413TR'

Member P52010 of dimension PRC has an invalid hierarchy parent '0750PG2408V'

Member P50030 of dimension PRC has an invalid hierarchy parent '0750PG2408STAB'

Member P50310 of dimension PRC has an invalid hierarchy parent '0750PG2408PT'

Member P51332 of dimension PRC has an invalid hierarchy parent '0750PG3446SF'

Member PG3442REGN of dimension PRC has an invalid hierarchy parent '0750PG3442REG'

Member P13270 of dimension PRC has an invalid hierarchy parent '0750PG3442REGM'

Member P37300 of dimension PRC has an invalid hierarchy parent '0750PG2128CAP'

Member P59040 of dimension PRC has an invalid hierarchy parent '0750PG2127DON'

Member P30600 of dimension PRC has an invalid hierarchy parent '0750PG2127STAB'

Member P11125 of dimension PRC has an invalid hierarchy parent '0750PG4421R'

Member P11400 of dimension PRC has an invalid hierarchy parent '0750PG4414LC'

Member P11121 of dimension PRC has an invalid hierarchy parent '0750PG4413O'

Member PG4196REGN of dimension PRC has an invalid hierarchy parent '0750PG4196REG'

Member P13314 of dimension PRC has an invalid hierarchy parent '0750PG4196REGM'

Member P11104 of dimension PRC has an invalid hierarchy parent '0750PG4177G'

Member PG4167REGN of dimension PRC has an invalid hierarchy parent '0750PG4167REG'

Member P13313 of dimension PRC has an invalid hierarchy parent '0750PG4167REGM'

Member P11109 of dimension PRC has an invalid hierarchy parent '0750PG4167V'

Member P11404 of dimension PRC has an invalid hierarchy parent '0750PG3129LC'

Member P11205 of dimension PRC has an invalid hierarchy parent '0750PG3129FM'

Member P11204 of dimension PRC has an invalid hierarchy parent '0750PG4442FM'

Member P58614 of dimension PRC has an invalid hierarchy parent '0750PG3199O'

Member P13652 of dimension PRC has an invalid hierarchy parent '0750PG4494FU'

Member P58290 of dimension PRC has an invalid hierarchy parent '0750PG3121CL'

Member PG3102REGS of dimension PRC has an invalid hierarchy parent '0750PG3102REG'

Member P13704 of dimension PRC has an invalid hierarchy parent '0750PG3102REGN'

Member P13524 of dimension PRC has an invalid hierarchy parent '0750PG3102REGM'

Member P57122 of dimension PRC has an invalid hierarchy parent '0750PG3101LS'

Member P58260 of dimension PRC has an invalid hierarchy parent '0750PG3132CL'

Member P58170 of dimension PRC has an invalid hierarchy parent '0750PG3122CL'

Member P14103 of dimension PRC has an invalid hierarchy parent '0750PG4333RS'

Member P47040 of dimension PRC has an invalid hierarchy parent '0750PG4333RSP'

Member P48110 of dimension PRC has an invalid hierarchy parent '0750PG4314RA'

Member P46320 of dimension PRC has an invalid hierarchy parent '0750PG4313BE'

Member P13198 of dimension PRC has an invalid hierarchy parent '0750PG4159REGV'

Member P13788 of dimension PRC has an invalid hierarchy parent '0750PG4159REGN'

Member P56600 of dimension PRC has an invalid hierarchy parent '0750PG4133LM'

Member P56334 of dimension PRC has an invalid hierarchy parent '0750PG4133MS'

Member PG4131REGS of dimension PRC has an invalid hierarchy parent '0750PG4131REG'

Member P13700 of dimension PRC has an invalid hierarchy parent '0750PG4131REGN'

Member P13289 of dimension PRC has an invalid hierarchy parent '0750PG4131REGM'

Member PG4124REGV of dimension PRC has an invalid hierarchy parent '0750PG4124REG'

Member P13070 of dimension PRC has an invalid hierarchy parent '0750PG4124REGS'

Member P13750 of dimension PRC has an invalid hierarchy parent '0750PG4124REGN'

Member P13351 of dimension PRC has an invalid hierarchy parent '0750PG4124REGM'

Member PG9941CENT of dimension PRC has an invalid hierarchy parent '0750PG9941'

Member P17150 of dimension PRC has an invalid hierarchy parent '0750PG9919IS'

Member P17411 of dimension PRC has an invalid hierarchy parent '0750PG9908CO2'

Member P17223 of dimension PRC has an invalid hierarchy parent '0750PG9907CO2'

Member P17558 of dimension PRC has an invalid hierarchy parent '0750PG9953RD'

Member P18102 of dimension PRC has an invalid hierarchy parent '0750PG9957RE'

Member P23000 of dimension PRC has an invalid hierarchy parent '0750PG2881SS'

Member P11420 of dimension PRC has an invalid hierarchy parent '0750PG2871LC'

Member P23020 of dimension PRC has an invalid hierarchy parent '0750PG2871SS'

Member P24150 of dimension PRC has an invalid hierarchy parent '0750PG1724PG'

Member P23090 of dimension PRC has an invalid hierarchy parent '0750PG1722SS'

Member P26030 of dimension PRC has an invalid hierarchy parent '0750PG2877TP'

Member P23070 of dimension PRC has an invalid hierarchy parent '0750PG2875SS'

Member P25040 of dimension PRC has an invalid hierarchy parent '0750PG2872NM'

Member P28020 of dimension PRC has an invalid hierarchy parent '0750PG2221OWC'

Member P20540 of dimension PRC has an invalid hierarchy parent '0750PG2211PPST'

Member P51350 of dimension PRC has an invalid hierarchy parent '0750PG2451SF'

Member P54010 of dimension PRC has an invalid hierarchy parent '0750PG2425FI'

Member P53190 of dimension PRC has an invalid hierarchy parent '0750PG2425CO'

Member PG2413REGN of dimension PRC has an invalid hierarchy parent '0750PG2413REG'

Member P13511 of dimension PRC has an invalid hierarchy parent '0750PG2413REGM'

Member P50360 of dimension PRC has an invalid hierarchy parent '0750PG2413TR'

Member P52020 of dimension PRC has an invalid hierarchy parent '0750PG2408V'

Member P50040 of dimension PRC has an invalid hierarchy parent '0750PG2408STAB'

Member P50320 of dimension PRC has an invalid hierarchy parent '0750PG2408PT'

Member P51333 of dimension PRC has an invalid hierarchy parent '0750PG3446SF'

Member PG3442REGS of dimension PRC has an invalid hierarchy parent '0750PG3442REG'

Member P13670 of dimension PRC has an invalid hierarchy parent '0750PG3442REGN'

Member P13440 of dimension PRC has an invalid hierarchy parent '0750PG3442REGM'

Member P51200 of dimension PRC has an invalid hierarchy parent '0750PG2617SF'

Member P59041 of dimension PRC has an invalid hierarchy parent '0750PG2127DON'

Member PG5500CENT of dimension PRC has an invalid hierarchy parent '0750PG5500'

Member P14060 of dimension PRC has an invalid hierarchy parent '0750PG7712TU'

Member P11130 of dimension PRC has an invalid hierarchy parent '0750PG5499R'

Member P11135 of dimension PRC has an invalid hierarchy parent '0750PG4421LW'

Member P11126 of dimension PRC has an invalid hierarchy parent '0750PG4421R'

Member P11320 of dimension PRC has an invalid hierarchy parent '0750PG4493O'

Member P14050 of dimension PRC has an invalid hierarchy parent '0750PG4414REG'

Member P11401 of dimension PRC has an invalid hierarchy parent '0750PG4414LC'

Member P11124 of dimension PRC has an invalid hierarchy parent '0750PG4413O'

Member PG4196REGS of dimension PRC has an invalid hierarchy parent '0750PG4196REG'

Member P13734 of dimension PRC has an invalid hierarchy parent '0750PG4196REGN'

Member P13323 of dimension PRC has an invalid hierarchy parent '0750PG4196REGM'

Member PG4167REGS of dimension PRC has an invalid hierarchy parent '0750PG4167REG'

Member P13733 of dimension PRC has an invalid hierarchy parent '0750PG4167REGN'

Member P13322 of dimension PRC has an invalid hierarchy parent '0750PG4167REGM'

Member P11405 of dimension PRC has an invalid hierarchy parent '0750PG3129LC'

Member P11206 of dimension PRC has an invalid hierarchy parent '0750PG4442FM'

Member P58615 of dimension PRC has an invalid hierarchy parent '0750PG3199O'

Member P13653 of dimension PRC has an invalid hierarchy parent '0750PG4494FU'

Member P58340 of dimension PRC has an invalid hierarchy parent '0750PG3121CL'

Member PG3102REGV of dimension PRC has an invalid hierarchy parent '0750PG3102REG'

Member P13014 of dimension PRC has an invalid hierarchy parent '0750PG3102REGS'

Member P13714 of dimension PRC has an invalid hierarchy parent '0750PG3102REGN'

Member P13534 of dimension PRC has an invalid hierarchy parent '0750PG3102REGM'

Member P57123 of dimension PRC has an invalid hierarchy parent '0750PG3101LS'

Member P58360 of dimension PRC has an invalid hierarchy parent '0750PG3132CL'

Member P58180 of dimension PRC has an invalid hierarchy parent '0750PG3122CL'

Member P14104 of dimension PRC has an invalid hierarchy parent '0750PG4333RS'

Member P47050 of dimension PRC has an invalid hierarchy parent '0750PG4333RSP'

Member P48210 of dimension PRC has an invalid hierarchy parent '0750PG4314RA'

Member P46330 of dimension PRC has an invalid hierarchy parent '0750PG4313BE'

Member P56603 of dimension PRC has an invalid hierarchy parent '0750PG4133LM'

Member P56341 of dimension PRC has an invalid hierarchy parent '0750PG4133MS'

Member PG4131REGV of dimension PRC has an invalid hierarchy parent '0750PG4131REG'

Member P13020 of dimension PRC has an invalid hierarchy parent '0750PG4131REGS'

Member P13709 of dimension PRC has an invalid hierarchy parent '0750PG4131REGN'

Member P13300 of dimension PRC has an invalid hierarchy parent '0750PG4131REGM'

Member P13190 of dimension PRC has an invalid hierarchy parent '0750PG4124REGV'

Member P13071 of dimension PRC has an invalid hierarchy parent '0750PG4124REGS'

Member P13761 of dimension PRC has an invalid hierarchy parent '0750PG4124REGN'

Member P13352 of dimension PRC has an invalid hierarchy parent '0750PG4124REGM'

Regards,

Apoorva

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Some node members have special character "-" which is missed in the conversion....and looks like your nodes are not loaded during the master data loading which is why the error of invalid hierarchy parent name..

Regards,

JP

Former Member
0 Kudos

Why have you used SUPPRESSCHARACTER=R70750???

Screenshot of BW hierarchy!

former_member186338
Active Contributor
0 Kudos

First strange thing:

*CONVERSION
HIER_NAME=PRC_HIER.xls!CONVERSION
NODENAME=PRC_HIER.xls!NODENAME
HIER_NAME=PRC_HIER.xls!NODENAME

Duplicate!

May be:

*CONVERSION
HIER_NAME=PRC_HIER.xls!CONVERSION
NODENAME=PRC_HIER.xls!NODENAME
PARENT=PRC_HIER.xls!NODENAME

And please check formats of NODENAME and PARENT...