Skip to Content
0
Former Member
Jul 27, 2016 at 09:44 PM

Custom Hierarchy based fields in a table

50 Views

Hello BW/BI experts,

I need your ideas here.

I have a table T with fields T.A, T.B, T.C. All fields have data, but the data in ECC source system is not organized in a hierarchy structure.

I need to create a hierarchy structure in BW as in the follow

A _BValu1

_BValue2

_BValue3_CValue1

_CValue2

Etc.

Can you pls share your valuable knowledge and experience on how to achieve this ?

I tried to use A infoObject as external to B hierarchy OBJCT , and B as external to C hierarchy IOBJ, but it not working to me. I gives me the following error :

Error deriving hierarchy InfoObject from field



Thanks for sharing your valuable experience and knowledge

JHN