Error while loading Hierarchies from BPC InfoObject into BW

[venkat_kodi]

Hello all,

   We need to update Master Data (Text, Attributes and Hierarchy) from Planning Unit InfoObject (/CPMB/BPD9T3W)

generated by BPC to BW Infobject, so we made the transformation and DTP for Text, Attributes and Hierarchy.

It works fine for Text and Attributes, but not for Hierarchy and gives the follow error:

How to resolve it so that I could load the Hierarchies from BPC InfoObject into BW, please?

Thanks,

Venkat.

[RafkeMagic · Accepted solution]

check your transformation... you need to "convert" the InfoObject in the 1-1 routine(s) (from /CPMB/BPD9T3W to ZBPSUNIT)

[venkat_kodi · Accepted solution]

Hello Raf,

   Thank you for your response and could you please explain in detail.

Thanks,

Venkat.

[RafkeMagic · Accepted solution]

go to the Hierarchy Structure transformation (by clicking on the Source Segments or Target Segments and selecting Hierarchy Structure)

there you probably have all 1-1 mappings as well (which is incorrect in your case)

more specifically check the rule for 0H_IOBJNM, your code (to be inserted) could look like:

IF SOURCE_FIELDS_3-H_IOBJNM EQ '/CPMB/BPD9T3W'.

  RESULT = 'ZBPSUNIT'.

ELSE.

  RESULT = SOURCE_FIELDS_3-H_IOBJNM.

ENDIF.

[venkat_kodi · Accepted solution]

Hello Raf,

   I have created the routine as you mentioned, but getting the below error, please.

Thanks,

Venkat.

[RamanKorrapati · Accepted solution]

Hi Venkat,

info object ZBPSUNIT - What kind of info object is this?

Have You converted your info object as info provider?

Thanks

[venkat_kodi · Accepted solution]

Hello Raman,

      The InfoObject  ZBPSUNIT is InfoProvider type only.

Thanks,

Venkat.

[RafkeMagic · Accepted solution]

Do you even know what you are doing?

I clearly stated that the code COULD look at whatever I put there... you just needed to use the correct InfoObject names... scrolling back up I see that I made a typo and your InfoObject contains another P somewhere... I guess you SHOULD find out yourself where exactly

[RamanKorrapati · Accepted solution]

Hi Venakt,

At which environment your doing?

is it dev system or ideas?

ZBPSUNIT - is it active at your bw system?

can you share ZBPSUNIT INFO object screen shot from RSA1.

Thanks.

[RafkeMagic · Accepted solution]

that InfoObject does not exist

[RamanKorrapati · Accepted solution]

Seems like he is new to bw.

[venkat_kodi · Accepted solution]

Hello Raman,

     I am doing in Sandbox and the InfoObject ZBPSPUNIT is ACTIVE. I have 14+ years in BW, but never loaded hierarchies from BPC to BW.

Thanks,

Venkat.

[RamanKorrapati · Accepted solution]

Sorry Venkat about my statement.

Even me also, never loaded hier from BPC to BW.

From what object you connected to info object ZBPSPUNIT?

One thing i want to know, how you had hier at BPC side?

have you loaded from BW to BPC? or manually built at bpc side?

In generally, we load data from BW to BPC whether master data(Attr/Hier) or Transaction data.

Thanks.

[venkat_kodi · Accepted solution]

Hello Raf,

     Sorry, I found my typo. I used the InfoObject ZBPSUNIT instead of ZBPSPUNIT. Now it worked fine. Thank you very much for your suggestion.

Regards,

Venkat.

[venkat_kodi · Accepted solution]

Hello Raman,

    It's ok. I used the InfoObject ZBPSUNIT instead of ZBPSPUNIT. Now it worked fine.

    The hierarchies are manually built on BPC side. Yes, generally, we load the data from BW to BPC, but we want the other way around.

Thanks,

Venkat.

[RamanKorrapati · Accepted solution]

Nice to know Venkat.

Have a great weekend.